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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the importance of surrogate key in data warehousing?

719


What is ds designer?

659


What is the sortmerge collector?

670


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1638


What are the differences between datastage and informatica?

572






Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2440


Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1124


What is a merge in datastage?

774


How do you start developing a datastage project?

663


What is "fatal error/rdbms code 3996" error?

666


how to sort two columns in single job in datastage.

2549


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

1476


explain about citrix scheduling tool in datastage

1813


Can we use target hash file as a lookup ?

2820


How to convert RGB Value to Hexadecimal values in datastage?

3463