table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answer Posted / rajesh.dwh
To do this in server job: use merge stage/transformer stage
to join these two tables (Ta and Tb) mapping them and load
it into target (sequential/ODBC/ORACLE) etc.
To do this in parallel job: use merge/joiner stage and do
above task.
thanks & regards:
todbarajesh@gmail.com
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Can you filter data in hashed file?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How do you register plug-ins?
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?
EXPLAIN SCD
What are the stages in datastage?
Explain how a source file is populated?
how to export or import the jobs in .ISX file
Define data aggregation?
How a server job can be converted to a parallel job?
Explain ibm infosphere information server and highlight its main features?
What are the different options associated with dsjob command?
How rejected rows are managed in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the important features of datastage?