INPUT file 'A' contains:
1
2
3
4
5
6
7
8
9
10
input file 'B' contains:
6
7
8
9
10
11
12
13
14
15
Output file 'X' contains:
1
2
3
4
5
Output file 'Y' contains:
6
7
8
9
10
Output file 'Z' contains:
11
12
13
14
15
How can we implement this in a single ds job?
Answer Posted / shar
ok i shouldn't have hard coded with values.
Can u plz be more clear with the solution u gave with stages
and flows properly.
Thanks in advance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What a datastage macro?
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 difference between join, merge and lookup stage?
What is the importance of the exception activity in datastage?
Why do you need stage variables?
Can you highlight the main features of ibm infosphere information server?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How many Key we can define in remove duplicate stage?
What is a merge in datastage?
EXPLAIN SCD
What is orabulk stage?
how many rows sorted in sort stage by default in server jobs
How to reverse the string using unix?
Define project in datastage?
how to implement scd2 in datastage 7.5 with lookup stage