on 02-27-2015 3:09 AM
Hello experts,
I have created multiple views in Information Steward Data Insight with rules and scorecards based on one database table in the source database. Now I have been told the table I used is going to be deleted and there is another table with same fields and data I need to use now. I want to know if there is an easy way in Information Steward to just replace the table name in all the views using this table that is going to be deleted. I would appreciate your help and guidance.
Message was edited by: Julie Oliver
Hi Purvi,
The easiest option would be to create a database view on top of the new table with the same naming as the original table.
Regards
Nigel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Nigel! That seems to be great solution. Have you already tried this before? By creating view on top of new table with the same name won't break anything on Data Insight, meaning I do not need to modify view and re-bind rules and reconfigure scorecards. Correct?
Thanks Dirk! Have you already tested with synonym before?
I appreciate the quick replies
Regards,
Purvi.
Thanks Nigel for confirming! I appreciate your help!!
Dirk, I think Synonym may be a good work around and it will work but in my opinion it is not a good practice to keep table and synonym different. My DBAs would like to keep it consistent. I think I will go with creating view on new table with same name as old table which reduces amount of rework and is safe. I appreciate your help and quick replies!
Regards,
Purvi.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.