Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 11429 Views
- IBM, I also Faced
- E-Mail Answers
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 ibm datastage?
What are the different plug-ins stages used in your projects?
how to add a new records into source?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the components of datastage?
What are sequencers?
options available in sequence job to run,validate?
Difference between data warehousing and olap?
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
How to reverse the string using SQL?
Define Routines and their types?
How do you remove duplicate values in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
