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

Answer Posted / kiran

Hai..,
This is Kiran.
In SCD's type we r using change capture and transfernar
stage.
date fields are using in target level as Eff_start_date and
Eff_end_date.

Eff_start_date=current date
Eff_end_date =Currentdate-1.

If any mail me

Regards
Kiran
9393363309

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of views in datastage director?

1249


what is the custome stage in datastage? how can we impliment that one? plz tell me

1911


how to abort the job its matain duplicates?

2107


What steps should be taken to improve Datastage jobs?

641


Different ways a project can be moved to production ?...example ….export-import and Version control.

1935






What is the difference between hashfile and sequential file?

722


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1035


Where do the datastage jobs get stored?

731


How to perform incremental load in datastage?

668


Where do you see different stages in the designer?

630


How many types of hash files are there?

611


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

623


What are the different plug-ins stages used in your projects?

625


How many types of views are there in a datastage director?

834


What is a ds designer?

642