how can or from where we can get reference data in scd type2
implementation?
Answers were Sorted based on User's Feedback
Answer / d anil babu
in change capture before data.or intial load data take refence
for delta load.
| Is This Answer Correct ? | 0 Yes | 2 No |
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
Define Data Stage?
Difference in the implementation of lookup and join stages,in joining two tables?
what is the diff b/w switch and filter stage in datastage
What is staging variable?
How do you import and export the datastage jobs?
what is combinability and non combinability?
Name the third party tools that can be used in datastage?
Is it possible to query a hash file?
1)Source file contains one record, I want 100 records in target file.