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 / subbuchamala
Shar,
You explained the same as my 2nd method with examples.
Thanks
Subhash
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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 orabulk stage?
Can we use target hash file as a lookup ?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are orabulk and bcp stages?
What is the precedence of stage variables,derivations, and constraints?
Can you explain link buffering?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what is the use of skid in reporting?
Explain the situation where you have applied SCD in your project?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
how to abort the job its matain duplicates?
How to reverse the string using unix?
whom do you report?
what is 'reconsideration error' and how can i respond to this error and how to debug this