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
How to convert RGB Value to Hexadecimal values in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is size of a transaction and an array means in a datastage?
Differentiate between operational datastage (ods) and data warehouse?
What is the difference between informatica and datastage?
What is quality stage?
what is use of SDR function?
What are the areas of application?
Define project in datastage?
Why do we use link partitioner and link collector in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
sed,awk,head
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
In Datastage, how you can fix the truncated data error?
Define orabulk and bcp stages?