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?
Answer Posted / vinod upputuri
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 |
Post New Answer View All Answers
How many types of hash files are there?
Can you explain tagbatch restructure operator?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What all are the different way to run a job?
What steps should be taken to improve Datastage jobs?
Nls stands for what in datastage?
What is the roundrobin collector?
Name the third party tools that can be used in datastage?
Define project in datastage?
What is a folder? Difference types of stages?
Why we use surrogate key?
What is the different type of jobs in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How a routine is called in datastage job?
Can you highlight the main features of ibm infosphere information server?