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 are the benefits of datastage?
Differentiate between datastage and datastage tx?
What are transforms and what is the differenece between routines and transforms?
How a routine is called in datastage job?
Demonstrate experience in maintaining quality process standards?
On which Dimension Table you implemented SCD Type in your Project
Describe the main features of datastage?
What is the project in datastage?
How to clean the datastage repository?
what is the use of materialized view?
How to manage date conversion in Datastage?
Define repository tables in datastage?
What is the difference between account and directory options ?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How do you generate sequence number in datastage?