Interested to Buy Any Domain ? << Click Here >> for more details...
table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
- 9 Answers
- 15115 Views
- I also Faced
- E-Mail Answers
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
What is the different type of jobs in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Explain ibm infosphere information server and highlight its main features?
What are the functionalities of link partitioner and link collector?
Define Data Stage?
Define Job control?
Explain datastage architecture?
Describe routines in datastage? Enlist various types of routines.
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
root tree will find which is server job and which is parallel job?
What are some different alternative commands associated with "dsjob"?
What is the differentiate between data file and descriptor file?
What are the areas of application?
If you want to use the same piece of code in different jobs, how will you achieve it?
