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
- 11092 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 |
on how many columns we can perform aggregation in the Aggregator stage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is orabulk stage?
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
What are the job parameters?
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
What is ibm datastage flow designer?
What is process model?
How many Key we can define in remove duplicate stage?
What is the version control how can i apply this in DataStage can any one tell me the anser
Teradata 
