Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 6407 Views
- IBM, PR3 Systems, I also Faced
- E-Mail 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 sort two columns in single job in datastage.
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is a merge?
How to find value from a column in a dataset?
Define ds designer?
How can we improve performance of data stage jobs?
What are the various kinds of the hash file?
Nls stands for what in datastage?
How to Remove Duplicate using SQL?
If you want to use a same piece of code in different jobs, how will you achieve this?
Define repository tables in datastage?
What is the difference between validated and compiled in the datastage?
What is meta stage?
What are the different kinds of views available in a datastage director?
whom do you report?
