[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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now