Sometimes in your projects you might need to accomodate a change in table column names. The process earlier was to manually unlink the dependent attributes, and then update the table structure using the WH catalog. Thanks to Architect tool, the process is much simpler now. I have three tables and in one of the table, the ID form for Attribute A1 is pointing to column A11. This column is changed to columan name A1.
The below is the screen shot of the changes that needs to be done using Architect.
Open the Architect from Schema menu, and go to table view.
Right click on the table and update structure. You will see the new table as below. A1 is the new column name.
Now you need to modify the definition of A1 attribute to include this change.
In my project attribute A1 has multiple ID forms. This is why you are seeing two definitions. . I want to remove A11 since column name A11 does not exist anymore and i dont reference it in any other tables.
You cannot just choose the defnition for A1 column without deleting / removing A11 definition.
Once you are done, go to hierarchy view. You will see that the relationship is broken
Click on A2 and frag a line pointint to A1. The Architect will create the relationship between these two attributes.
Save and update scema and you are done :)
No comments:
Post a Comment