[resolved] Rapidly Changing Dimension Implementation(SCD Type4)

One Star

[resolved] Rapidly Changing Dimension Implementation(SCD Type4)

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

Accepted Solutions
One Star

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

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

All Replies
Six Stars

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

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-dim..."
Thanks,
Jagadish.
One Star

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

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