how can we extract data with out having any common column
Answer Posted / bietl
Hi,
it's just simple as this..
Suppose we have two tables T1 and T2.
Now load the two tables to Seq.files as S1 and S2.
T1............ S1
T2............. S2
Now S1 and S2 are our two seq.files load the two files data
by selecting the S2 seq.file option as append then we will
get the S1 and S2 data as same as T1 and T2.
I hope it will clarify ur question
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
EXPLAIN SCD
how to write server Routine coding?
What are the different layers in the information server architecture?
Explain datastage architecture?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is size of a transaction and an array means in a datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the purpose of pivot stage?
What is a quality stage in datastage tool?
Differentiate between data file and descriptor file?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the difference between odbc and drs stage?
How many types of sorting methods are available in datastage?
What are the components of ascential data stage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE