on 03-28-2014 1:21 PM
Hi Team,
Is there any way to update the target table without table comparsion transformation. TC is taking so much of time for upsert operation or any other optimization technique to improve the performance of the TC and Map opeation.
Thanks
Hi Gokul ,
You can use Auto Correct Load Option into Target table.
Cheers,
Shiva Sahu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Join two tables or use update command in a script after the dataflow. But both the methods are not efficient as TC. What comparison method are you using in TC?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.