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

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

i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?

2 Answers  


job locking methods? How can we unlock the job?

3 Answers   IBM,


hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers   Polaris,


what is time dimension? and how to populate time demension

2 Answers   TCS,


SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  






What is the default execution order of the sequential file?

3 Answers  


What is the difference between passive stage and active stage?

0 Answers  


Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,


Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,


How many areas for files does datastage have?

0 Answers  


i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,


What is use Array size in datastage

0 Answers  


Categories