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
Name the third party tools that can be used in datastage?
sed,awk,head
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Explain datastage architecture?
root tree will find which is server job and which is parallel job?
Enlist various types of routines in datastage.
Difference between server jobs & parallel jobs?
how can we create rank using datastage?what is the meaning of rank?
how to abort the job its matain duplicates?
Have you used Unstructured data?
Describe stream connector?
Explain Quality stage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How to read multiple files using a single datastage job if files have the same metadata?