need help for data migration
Posted: Wed May 24, 2006 12:45 am
Hi All,
i am handling one data migration project. In the source there 54 database having around 900+ tables. now clients wants to migrate data (around 500+ table) in the target(db2) after transformation and apply business rule. For this they r planning to have one EDM in staging area. also they planned to use profile stage for cleansing, removing duplication and integration etc?
what i am thiking why EDM in staging area, it should be in target.
And also as far i know datstage server job is sufficent for data migration.
My question are
1-> Is there any benefit i can gain of using EDM in staging area ?
2-> Is DS server job sufficient for handling all cleansing operation or we need to have
profile stage for that?
i have little bit knowldege of data migration.
please help me!!
Any idea and suggestion will be very much help ful to me.
Thanks and Regard,
Rafiq
i am handling one data migration project. In the source there 54 database having around 900+ tables. now clients wants to migrate data (around 500+ table) in the target(db2) after transformation and apply business rule. For this they r planning to have one EDM in staging area. also they planned to use profile stage for cleansing, removing duplication and integration etc?
what i am thiking why EDM in staging area, it should be in target.
And also as far i know datstage server job is sufficent for data migration.
My question are
1-> Is there any benefit i can gain of using EDM in staging area ?
2-> Is DS server job sufficient for handling all cleansing operation or we need to have
profile stage for that?
i have little bit knowldege of data migration.
please help me!!
Any idea and suggestion will be very much help ful to me.
Thanks and Regard,
Rafiq