Send a Message
to Malineni_16

Comments

1

Joined

May 25, 2011

Malineni_16 Profile

Forums Owned

Recent Posts

Informatica

History Migration using Informatica

We have a requirement where in we have to migrate the data from Oracle to Teradata.We are maintaining SCD 2 in Oracle with a flag value of N for old records and Y for the new records.In Teradata, we will be having limited columns and flag value column will not be there. As we are not having all the columns in Teradata, there will be duplicates. These duplicates has to be removed and SCD 2 has to be maintained with start date and end date. The biggest table is having 97M records.Can ayone suggest me the best way for doing this considering the performance.  (May 25, 2011 | post #1)