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
How do you remove duplicate values in datastage?
What all are the different way to run a job?
What is the method of removing duplicates, without the remove duplicate stage?
root tree will find which is server job and which is parallel job?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is a merge in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How one source columns or rows to be loaded in to two different tables?
How do you generate sequence number in datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are datastage sequences?
Name the different sorting methods in datastage.
Differentiate between datastage and informatica?
Why fact table is in normal form?