[resolved] Rapidly Changing Dimension Implementation(SCD Type4)

Highlighted
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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads