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
Right click subject and select "Update Query Subject"
Steve
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.
Thanks Blue !! The 'Update Object' worked.
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.