How to Implement SCD Type 2 WIthout using Lookup with Target

[Anonymous]

Hi All,

I want to implement SCD Type 2. Simply i can do with Lookup on Target table. But My Target Table is having huge records. So i think if i will perform lookup on this again performance will become very bad. Because target table is having billions of records.

Is there any way to implement SCD Type 2 without using lookup.

Regards,

Vishal Vats

+91-9650236023

[Anonymous]

@vishuoo1 

Hi Vishal,

     I could see that you have posted same query twice and other community members have already responded to your query in that post.

https://community.talend.com/t5/Design-and-Development/How-to-Implement-SCD-Type-2-WIthout-using-Loo...

    I humbly request you not to create duplicate posts for same queries as it will create strain on resources. Could you please close this post and followup on the other post which is active?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂