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
Define meta stage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the areas of application?
On which Dimension Table you implemented SCD Type in your Project
Name the third party tools that can be used in datastage?
What is the difference between server job and parallel jobs?
Differentiate between datastage and informatica?
What are the some differences between 7.x and 8.x version of datastage?
What a datastage macro?
Can you explain kafka connector?
Distinguish between informatica & datastage. Which one would you choose and why?
What are some prerequisites for datastage?
Describe the main features of datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the enhancements made in datastage 7.5 compare with 7.0?