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 / sarita
Hi Shar,
You aret hardcoding the values in your approach.I think the other approach could be:
1)Take a left outer join on the tables A and B. Common column for join can be a dummy=1.
2)Now output would be 2 columns one will have values 1,2,3,4,5,6,7,8,9,10 other will have NULL....NULL...6,7,...10
in expression transf...take a variable... chk when col a- col b != 0,then put flag X else Y
3)Then similarly do a join for B & C table and use same logic
Hope it works!
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Define orabulk and bcp stages?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How do you import and export the datastage jobs?
what is repositery?
How a routine is called in datastage job?
How do y read Sequential file from job control?
Lookup constraints
What are sequencers?
Can you highlight the main features of ibm infosphere information server?
How the ipc stage work?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is aggtorec restructure operator?
What are the enhancements made in datastage 7.5 compare with 7.0?