One Star

Which would be better option to handle Historization in Talend tool

Hi,
I am trying to implement Data warehouse using Talend 6.21. I have implemented Historization using SCD components. Wanted to know whether implementation of SCD using components available in talend is a better option or creating a job using tmap and other components to handle is better. Please suggest and Is their any impact from future Talend releases and with respect to performance as well.
2 REPLIES
Moderator

Re: Which would be better option to handle Historization in Talend tool

Hi,
Usually, we use tXXXSCD component to address Slowly Changing Dimension needs, read regularly a source of data and logging the changes into a dedicated SCD table.
For your Historization requirement, could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Which would be better option to handle Historization in Talend tool

Thank you for your input. 
I am implementing SCD Type 1 and SCD Type 2.
Exmaple for SCD Type 1 one:
Input table: Product

Example for SCD Type 2

So for these scenarios can you let me know will there be any difference inn performance between SCD component  and manual(by using tmap and other components).