explain how to create SCD-2 IN DATASTAGE 7.5X2
PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE
AND JOB DESINGN URGENT
- 3 Answers
- 11051 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harikiran
we can implement scd-2 in ds 7.5.2 server jobs by using
hash file and transformer stage. here hash file can act as
a lookup table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / guest
http://etl-tools.info/en/datastage-tutorial-L008_scd-implementation-datastage.htm
| Is This Answer Correct ? | 0 Yes | 0 No |
What is quality stage?
How do you import and export data into datastage?
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
What is ibm datastage flow designer?
what is the unix script to run the job? Please mention commands which we use often?
What's the Main Function of the Staging area in DWH
what is the use of surogate key in datastage
how can find maximum salary by using Remove duplicate stage?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
why we use parameters instead of hard code in datastage
Why we need datasets ratherthan sequential files?
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early
Teradata 
