WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE
FIELD
Answer Posted / rajeshchunduri
in datastage 8.0.1 version we have a stage scd.
give new data i/p link to scd stage and old data link to
transformer and from transformer give it to scd. from scd we
ger to o/p links one is fact and other is dimension.now
update date comes to dimension table.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Differentiate between Join, Merge and Lookup stage?
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
options available in sequence job to run,validate?
What are the functionalities of link partitioner?
How a server job can be converted to a parallel job?
What is a merge in datastage?
Explain connectivity between datastage with datasources?
How you can fix the truncated data error in datastage?
Explain how a source file is populated?
How to read multiple files using a single datastage job if files have the same metadata?
Why do we use link partitioner and link collector in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is job control?
Name the third party tools that can be used in datastage?
What are constraints and derivations?