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


Please Help Members By Posting Answers For Below Questions

How do you remove duplicate values in datastage?

630


What all are the different way to run a job?

642


What is the method of removing duplicates, without the remove duplicate stage?

586


root tree will find which is server job and which is parallel job?

1451


Explain the datastage parallel extender (px) or enterprise edition (ee)?

735






What is a merge in datastage?

772


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

622


How one source columns or rows to be loaded in to two different tables?

662


How do you generate sequence number in datastage?

625


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

2272


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1718


What are datastage sequences?

670


Name the different sorting methods in datastage.

612


Differentiate between datastage and informatica?

727


Why fact table is in normal form?

675