Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 11 Answers
- 18273 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / sreenivas ramanathan
We can achieve this by using Change data capture stage as comparing the 2 inputs.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the benefits of datastage?
What is the use of datastage designer?
Why do you need stage variables?
Which commands are used to import and export the datastage jobs?
What is the use of datastage director?
Explain ibm infosphere information server and highlight its main features?
Distinguish between informatica & datastage. Which one would you choose and why?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Which algorithm you used for your hashfile?
How can one find bugs in job sequence?
why do u need the IOS upgradation in a FC switch
Explain the importance of surrogate key in data warehousing?
What is a ds designer?
Where do you see different stages in the designer?
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
