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

When we will go for Data elements?

3 Answers   TCS,


how to find out number of records imported into source file?

1 Answers  


if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  


Explain Quality stage?

0 Answers  


hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,


What are the steps needed to create a simple basic datastage job?

0 Answers  


Define Routines and their types?

0 Answers  


which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,


i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

0 Answers   Syntel,


how do u reduce warnings

1 Answers   CGI,


Categories