how can or from where we can get reference data in scd type2 implementation?

how can or from where we can get reference data in scd type2
implementation?

Question Posted / srinivas.p

2 Answers
7501 Views
JPMorgan Chase, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can or from where we can get reference data in scd type2 implementation?..

Answer / naga

in the before data

Is This Answer Correct ?

5 Yes

1 No

how can or from where we can get reference data in scd type2 implementation?..

Answer / d anil babu

in change capture before data.or intial load data take refence
for delta load.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More Data Stage Interview Questions

What is difference between server jobs & parallel jobs?

0 Answers

Can you define merge?

0 Answers

Does datastage support slowly changing dimensions ?

0 Answers

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers TCS,

Define Job control?

0 Answers

Is possible to create skid in dim,fact tables?

0 Answers NTT Data,

What is RCP?

2 Answers TCS,

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers Wipro,

What is data partitioning?

0 Answers

Which warehouse using in your datawarehouse

0 Answers IBM,

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

1 Answers

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

2 Answers IBM,

For more Data Stage Interview Questions Click Here