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

what is factless fact table?

3 Answers   IBM,


difference between server shared container and parallel shared container

6 Answers   CTS,


Can you highlight the main features of ibm infosphere information server?

0 Answers  


What is lookup table?

5 Answers  


in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,


Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,


what is advantages of snowflake when it is used?

3 Answers   IBM,


what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,


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?

1 Answers   IBM,


Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,


i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,


How did you reconcile source with target?

2 Answers   HP,


Categories