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
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
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is orabulk stage?
Differentiate between odbc and drs stage?
sed,awk,head
Whats difference betweeen operational data stage (ods) and data warehouse?
Different ways a project can be moved to production ?...example ….export-import and Version control.
CHANGE CAPTURE
What is size of a transaction and an array means in a datastage?
What is the use of datastage designer?
How do you schedule or monitoring the job?
explain about citrix scheduling tool in datastage
How to find value from a column in a dataset?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Describe the main features of datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?