Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12567 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is a merge in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the steps needed to create a simple basic datastage job?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Can you implement SCD2 using join, transformer and funnel stage?
how to sort two columns in single job in datastage.
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How to read the length of word in unix?
Why fact table is in normal form?
What is the precedence of stage variables,derivations, and constraints?
What are stage variables and constants?
What is the difference between in process and inter process?
How do you run datastage job from the command line?
What is the flow of loading data into fact & dimensional tables?
