Cascading meta data changes
Posted: Mon Aug 23, 2010 12:49 am
Hi All,
Need a suggestion on making the meta data changes to the code. The site is a data migration project and we had a new version of the target. Some of the fields in the target application has changed and in all case the length is increased. For example the manufacture code is increased from varchar2 ( 8 ) to varchar2 ( 16 ). At present we are importing the table definitions through OSH and manually changing the metadata on the stages! Is there any better way to do it. Tools like informatica has propagate data type changes option which makes the life easier. Please advise. Other than developing a text processing script over dsx/xml to change the data type do we have any other way to achieve this. Please advise or share your thoughts
Many Thanks
MSR
Need a suggestion on making the meta data changes to the code. The site is a data migration project and we had a new version of the target. Some of the fields in the target application has changed and in all case the length is increased. For example the manufacture code is increased from varchar2 ( 8 ) to varchar2 ( 16 ). At present we are importing the table definitions through OSH and manually changing the metadata on the stages! Is there any better way to do it. Tools like informatica has propagate data type changes option which makes the life easier. Please advise. Other than developing a text processing script over dsx/xml to change the data type do we have any other way to achieve this. Please advise or share your thoughts
Many Thanks
MSR