1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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?

Question Posted / satish


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

Can you filter data in hashed file?

0 Answers  

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

What are the benefits of datastage?

0 Answers  

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

What are the partition techniques available in your last project?

1 Answers  




eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers   HCL,

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

0 Answers  

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

what is combinability and non combinability?

2 Answers  

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

Is the value of staging variable stored temporarily or permanently?

0 Answers  

In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories