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...
Hi Experts, I wanted to change data conditionally. In the field Loc, for the value TBA the region should be changed to ME starting from year 2016. So any data before Year 2016 should be unchanged....
...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...
Conversion of Oracle SCD to Oracle ELT SCD isn't working. The tables previously loaded using the tOracleSCD component are not updating when using the tOracleSCDELT component.
R...
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, I need to calculate Average Net Price (grouped by Key A,B,C and Year) and store the result in table. The result table will be used in another calculation process. The issue is the Net P...
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...
