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 the difference between operational data stage (ods) and data warehouse?
Can you explain engine tier in information server?
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
How can one find bugs in job sequence?
What is the difference between Datastage 7.5 and 7.0?
Where the datastage stored his repository?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
In which situations we can use normal and sparse lookup stages
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the process of killing a job in datastage?
Is the value of staging variable stored temporarily or permanently?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?