Hi,
I need to insert the new records into the target. In this case I can use either a Join stage(left join) or a change capture stage.
Please let me know which is recommended for better performance.
Regards
Arnie.
Change capture or Left Join
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Define "performance" in an ETL context.
It's impossible to recommend techniques for "better performance" if one has no idea what "performance" is.
Also, there is no "one size fits all" solution. It always depends.
It's impossible to recommend techniques for "better performance" if one has no idea what "performance" is.
Also, there is no "one size fits all" solution. It always depends.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.