Change capture or Left Join

[arnie_nits]

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.

[Maveric]

Change capture stage with Drop set for copy, delete. And Edit if required. Also sort the data on both the input links.

[ray.wurlod]

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.