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
Answer Posted / sant532reddy
seq file1 and file2 as input to change capture stage and then a switch stage with case=0,1,2 (on change code). Case=0 will give 6,7,8. Case=1 will give 1,2,3,4,5 and case=2 will give you 9,10,11
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is size of a transaction and an array means in a datastage?
What is a ds designer?
What are system variables and sequencers in datastage
Can you explain repository tables in datastage?
Differentiate between hash file and sequential file?
Where do you see different stages in the designer?
How do you start developing a datastage project?
How to implement complex jobs in data stage?
What is the difference between passive stage and active stage?
how to add a new records into source?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the features of datastage flow designer?
How to convert RGB Value to Hexadecimal values in datastage?
Describe the architecture of datastage?
How can we improve performance of data stage jobs?