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 |
Nls stands for what in datastage?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
what is factless fact table?
On which Dimension Table you implemented SCD Type in your Project
can we see the data in fixed width file? how can u change the datatype of fixed width files?
Can you filter data in hashed file?
What is size of a transaction and an array means in a datastage?
How to read multiple files using a single datastage job if files have the same metadata?
How to implement complex jobs in data stage?
What are iconv and oconv?
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?
how to find no.of records in sequntial file itself?