Hi Experts,
I need to load all the records that are new or updates for Oracle source to SQL Server table. I am using SSIS for this. The approach i am using now is simple, that is, just truncating the destination table and loading all the records from source to destination everyday. So the loading of 24 million records everyday is taking about 50 minutes.
Just curious if lookup transformation will be faster.
Thanks..
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI