How u implement the slowly changing dimensions if my source
table is consisting of cid,cname,add,phno,email but i need to
capture the changes for first three columns how u implement?
This is done by using the Change_Capture_Stage.
In the CDS stage: specify the change key's--> cid and
change_values as cname,add and phone etc
CDC stage triggers the Change_code as 3 if there is any
changes in the cname or add or phone no for the existing cid.
Ex: cid,cname,add,phone,email
1,'vin','bang','08979','vin@Gmail.com'
REf:
cid,cname,add,phone,email
1,'vin','HYD','08979','vin@Gmail.com'
O/P: cid,cname,add,phone,email,Change_code
1,'vin','HYD','08979','vin@Gmail.com',3
Is This Answer Correct ? | 13 Yes | 0 No |
what is a nodemap constraint
what is data mapping
What is diff between Junk dimensions and conform dimension?
What are sequencers?
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
how to configure databases through datastage
Hi Vijay here For Four CPU's how many nodes will required?
How we can convert rows to columns in datastage?
source file contains 100 records, i want 10 records in target file how it possible in datastage
how to convert rows into columns
difference between server shared container and parallel shared container
1)Source file contains one record, I want 100 records in target file.