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 the difference between account and directory options ?

0 Answers  


I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,


HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

5 Answers   FIS,


How can u write exception handling in seq file????

2 Answers   IBM,


parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  






j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,


there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers  


What are stage variables and constants?

0 Answers  


What is the difference between the local container and shared container?

0 Answers  


Differentiate between Join, Merge and Lookup stage?

0 Answers  


what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,


Categories