|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/28/2008 3:52:19 PM
Posts: 81,
Visits: 94
|
|
Loading 350 million records from oracle to teradata takes around 15hrs using informatica fastload connection.
Performance of this need to be increased. Could you please help me on this to reduce the time it takes to load?
Properties used are - checkpoint(1 million)
error limit (500), tenacity(1),max sessions (20),
sleep(3), is_staged,truncate_target
Expecting quick response.
Regards,
Sakthi Do your duty Dont expect the reward, God will give the benefit for you
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 7:30:07 AM
Posts: 197,
Visits: 611
|
|
Hello,
It depends on the requirements. If they are flexible, you can create data file from oracle, and use that as input for Fastload. Next thing to consider is the network. Thirdly, you can try TPT.
HTH.
Regards,
Adeel
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/28/2008 3:52:19 PM
Posts: 81,
Visits: 94
|
|
We are using informatica for this.
Could you please give any performance pointsin that aspect?
Regards,
Sakthi Do your duty Dont expect the reward, God will give the benefit for you
|
|
|
|