WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE
FIELD

Answer Posted / pavani

scd type 2 stage used for the maintain the history,why we
are using the date function is that record is presently
record or past record identification purpose so for the past
record end_date is present record start_date these date
function used in tranformer stage.in this tranformer we
append 2 new coloumns that column names are start_date&
end_date as per my knowledge




this is pavani.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What all are the different way to run a job?

642


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

586


What is a datastage job?

617


describe the Steps to confiure a Qlogic switch

1937


Does datastage support slowly changing dimensions ?

661






What are sequencers?

616


What is data partitioning?

745


How a server job can be converted to a parallel job?

619


What are some different alternative commands associated with "dsjob"?

653


What are the some differences between 7.x and 8.x version of datastage?

740


what is use of SDR function?

4708


What can we do with datastage director?

674


How to manage date conversion in Datastage?

640


What is the importance of the exception activity in datastage?

624


What are transforms and what is the differenece between routines and transforms?

614