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
- 15427 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
How to perform incremental load in datastage?
In Datastage, how you can fix the truncated data error?
What are the components 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 components of ascential data stage?
What are the different kinds of views available in a datastage director?
What are the main features of datastage?
How many types of sorting methods are available in datastage?
Define Merge?
How can you write parallel routines in datastage PX?
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?
If you want to use a same piece of code in different jobs, how will you achieve this?
Enlist various types of routines in datastage.
What is the difference between an operational datastage and a data warehouse?
AGGREGATOR default datatype
