table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
- 9 Answers
- 12592 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
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 is the difference between Datastage 7.5 and 7.0?
Could anyone give brief explanation bout datastage admin
What is use Array size in datastage
If you want to use a same piece of code in different jobs, how will you achieve this?
How can you write parallel routines in datastage PX?
I have a few records just I want to store data in to targets cycling way how?
What is ibm datastage?
How do you import and export data into datastage?
explain about citrix scheduling tool in datastage
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is job control?
What is the sortmerge collector?
What is the different type of jobs in datastage?
how to add a new records into source?
