Author Topic: Import new columns in existing Model  (Read 1048 times)

Offline cognostechie

  • Statesman
  • ******
  • Posts: 753
  • Forum Citizenship: +55/-0
Import new columns in existing Model
« on: 07 Nov 2006 03:03:24 pm »
I have a package working with Oracle DB. They added some fields to existing tables. How do I bring those new fields in my tables (Query Subjects) ? When I run the Import Metadata wizard again, it brings the new fields but in a seperate query subject and it doesn't let me merge them to the same query subject.

Sorry, am new to Framework Manager.

Thanks

Offline almeids

  • Statesman
  • ******
  • Posts: 304
  • Forum Citizenship: +15/-2
Re: Import new columns in existing Model
« Reply #1 on: 08 Nov 2006 07:48:42 am »
Right click subject and select "Update Query Subject"
Steve

Offline Blue

  • Global Moderator
  • Community Leader
  • *****
  • Posts: 189
  • Forum Citizenship: +14/-0
  • The Earth is one country ... Baha'i Faith
    • Robert Edis Consulting
Re: Import new columns in existing Model
« Reply #2 on: 08 Nov 2006 11:45:52 am »
Select the querysubject, under the Tools menu option select Update Object.

If this doesn't work then

Right click on the query subject and select Edit Definition.  If the SQL is just SELECT * FROM table then delete this and drag the table from the list on the left into the SQL pane.  If the query subject is shows Query Items and Calculations instead of SQL for the right hand pane the use the Add option at the bottom of the window.
Robert Edis
Principal (and principled)
Robert Edis Consulting
Chicago USA

Offline cognostechie

  • Statesman
  • ******
  • Posts: 753
  • Forum Citizenship: +55/-0
Re: Import new columns in existing Model
« Reply #3 on: 08 Nov 2006 03:19:36 pm »
Thanks Blue !!  The 'Update Object' worked.


Offline Arpit Agrawal

  • Arpit Agrawal
  • Community Leader
  • *****
  • Posts: 91
  • Forum Citizenship: +3/-0
  • Have no fear of perfection--you'll never reach it.
    • Infocepts
Re: Import new columns in existing Model
« Reply #4 on: 14 Jun 2011 05:49:56 am »
Also you can Edit the defination of the Query Subject which would automatically refresh the columns present.But you need to add the columns in Consolidation view manually in case you have it.
Thanks and Best regards,
------------------------------------------------------------
Arpit Agrawal | InfoCepts | www.infocepts.com
------------------------------------------------------------