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?



How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,p..

Answer / 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

More Data Stage Interview Questions

difference between function and procedure...

1 Answers   IBM,


How can we run same job in 1 day 2 times

4 Answers   IBM,


What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,


what is meant by port ? what is the use of port ? what are the different type of ports and its usage

2 Answers   Accenture,


How many types of stage?

0 Answers  


What is ds designer?

0 Answers  


What is active and passive stage?

0 Answers  


Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,


How to Convert the columns into rows?

2 Answers  


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

0 Answers  


What is the difference between informatica and datastage?

0 Answers  


how to sort two columns in single job in datastage.

0 Answers   TCS,


Categories