There are two file are there .1st file contains 5 records and
2nd file contain 10 records in target they want 50 records.how
can achieve this
Answer Posted / bharath
Use query
>select * from tab1,tab2;
You get Cartesian Product of two table rows
if tab1 having m no.of an tab2 has n no of col
then mXn (m by n) rows are returned.
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
what is repositery?
Can you explain players in datastage?
What is "fatal error/rdbms code 3996" error?
What is apt_config in datastage?
CHANGE CAPTURE
What is the difference between validated and compiled in the datastage?
Define repository tables in datastage?
Differentiate between data file and descriptor file?
Define data aggregation?
Define Data Stage?
What are the processing stages?
what are the devoleper roles in real time? plz tell i am new to datastage....
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can we use target hash file as a lookup ?
client know skid info?