topic Re: [resolved] Rapidly Changing Dimension Implementation(SCD Type4) in Talend Studio

[resolved] Rapidly Changing Dimension Implementation(SCD Type4)

Anonymous — Sat, 16 Nov 2024 11:39:47 GMT

Hi
I am trying to implement Rapidly Changing Dimension in Talend.
I have used salesforce as input datasource and Oracle as DW.I have succesfuly implemented SCD Type2 But problem with SCD Type2 is that table becomes so huge easily and creates performance issues.So I want to implement Rapidly Changing Dimension(SCD Type4).
So Please let me know if anyone have implemented this before in Talend.
Snapshots of the demo job would be much helpful.
Thanks

With Regard
Sanjay Tiwari

Re: [resolved] Rapidly Changing Dimension Implementation(SCD Type4)

jagadish_dasari — Mon, 05 May 2014 12:16:49 GMT

Hi Sanjay,
Please look into article below. This might be of some help in your case.
" http://www.dwbiconcepts.com/data-warehousing/12-data-modelling/139-implementing-rapidly-changing-dimension.html"
Thanks,
Jagadish.

Re: [resolved] Rapidly Changing Dimension Implementation(SCD Type4)

Anonymous — Mon, 05 May 2014 12:35:56 GMT

Hi Jagadish,
Thanks for your reply.I have alredy gone through the link you have provided.I am very much clear with the concepts and i was looking for some implementation specially in Talend. Actually mini dimension created By Akash Mitra was creating a problem as he was solely implementing SAP'S logic to implement it.Now after few research i am clear with it that he was creating a factless fact tables.So i have implemented that in my case too.
With Regards
Sanjay Tiwari