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
Explain ibm infosphere information server and highlight its main features?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Why do you need stage variables?
Lookup constraints
How do you start developing a datastage project?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How the ipc stage work?
how to implement scd2 in datastage 7.5 with lookup stage
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.
What are routines in datastage? Enlist various types of routines.
how to delete one row in target dataset
What are the stages in datastage?
What are the processing stages?
What are the main differences you have observed between 7.x and 8.x version of datastage?
what is use of SDR function?