Require Comments on work i m thinking to develop in DS-7.1
Posted: Wed Nov 03, 2004 12:24 am
Hi Techies
I need a favour from your side . I am thinking of doing following work in DataStage 7.1
Please give ur valuable comments
Nature of Work : Data Migration from one data base to another.
Current Implementation : Java
Thinking of Moving to : DataStage7.1
Scope of Work: Migrating data from one database to another. Complexity involved is while migrating data for one table say x to another table y in new database we may have to do 5 to 6 lookups for referenc checks and also new database has effectivity. That is we create versions of records ( based upon the date). Same record can have different versions and based upon the current date we identify which record is effective. Also when adding or updating new record into new database effectivity needs to be maintained.
I think you might have by now general idea of migration involved.
I require your comments on this.
Should we go ahead with the datastage?
Can such a migartion be easily possible in DataStage?
Any risks or major factors that can hinder the process ?
....waiting for valuable reponse from you all.
Thanks in advance
Akash
I need a favour from your side . I am thinking of doing following work in DataStage 7.1
Please give ur valuable comments
Nature of Work : Data Migration from one data base to another.
Current Implementation : Java
Thinking of Moving to : DataStage7.1
Scope of Work: Migrating data from one database to another. Complexity involved is while migrating data for one table say x to another table y in new database we may have to do 5 to 6 lookups for referenc checks and also new database has effectivity. That is we create versions of records ( based upon the date). Same record can have different versions and based upon the current date we identify which record is effective. Also when adding or updating new record into new database effectivity needs to be maintained.
I think you might have by now general idea of migration involved.
I require your comments on this.
Should we go ahead with the datastage?
Can such a migartion be easily possible in DataStage?
Any risks or major factors that can hinder the process ?
....waiting for valuable reponse from you all.
Thanks in advance
Akash