Hello everyone, Video Demonstration: https://youtu.be/jA1dnwi--UQ Problem Overview I am encountering an issue where accumulated SCD Type 2 history in the Data Warehouse (DWH) is completely w...
...he job I get the following error: " Incorrect syntax near 'WHERE' " , repeated a number of times.
I included a screenshot below of the SCD setup.
Any help in d...
Hi,
Im almost sure that I saw this solved before in some blog/forum.. but currently Im not able to find it any more.
If I remember well it was using a tMap component.
I need to to make it in...
Hi,
I have a scenario regarding SCD2. I have to implement SCD2 based on Deleted field. i.e if deleted timestamp changes, then a new record should be created as active one and e...
Hi all, How can I implement scd type 2 without using scd type 2 components? For sample Id,name,course,key 1,xxx,jjj,k1 2,yyy,KKK,k2 For first load data will be loaded as its is.for s...
Hello I need your help to create the second table from the first table. I try to duplicate the dates on all subsequent records, until the next date appears and so on ... Thanks, Adiel
Hi,
I have to implement SCD2 logic(Insert/update) in my TOS code using SCD2 components. My Target DB is Amazon Redshift. Can you please let me know which TOS component needs to be used here ?Will t...
Hi Everyone,
I am trying implement SCD type1 in my project. I have created and run the job without context variables i my then it was running successfully, but i am trying to run the job w...
