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 are the different layers in the information server architecture?
Why do you need stage variables?
How to implement complex jobs in data stage?
Differentiate between validated and Compiled in the Datastage?
What is staging variable?
What is ds designer?
What are the job parameters?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is merge stage?
Explain ibm infosphere information server and highlight its main features?
What are the differences between datastage and informatica?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is the difference between datastage and datastage tx?
how do u catch bad rows from OCI stage? And what CLI stands for?
How many types of stage?