explain how to create SCD-2 IN DATASTAGE 7.5X2
PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE
AND JOB DESINGN URGENT
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 'reconsideration error' and how can i respond to this error and how to debug this
Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?
How to read multiple files using a single datastage job if files have the same metadata?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
What are the types of containers and how to create them?
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
What are constraints and derivations?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
how to sort two columns in single job in datastage.
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.