I have 2 Files like
fileA fileB Output1 Output2 Output3
1 6 1 6 11
2 7 2 7 12
3 8 3 8 13
4 9 4 9 14
5 10 5 10 15
6 11
7 12
8 13
9 14
10 15
please let know
- 6 Answers
- 8019 Views
- I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
You are right chetan, but in the second lookup we have to
use seq file 1 for main link and o/p2 is linked as reference.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the stages in datastage?
What are the some differences between 7.x and 8.x version of datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the difference between informatica and datastage?
How do you start developing a datastage project?
How to reverse the string using unix?
What are some different alternative commands associated with "dsjob"?
what are the devoleper roles in real time? plz tell i am new to datastage....
Why do you need stage variables?
Can we use target hash file as a lookup ?
What is meta stage?
How can you write parallel routines in datastage PX?
Explain Quality stage?
