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
- 15234 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
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Define orabulk and bcp stages?
What are the steps needed to create a simple basic datastage job?
What is the difference between orabulk and bcp stages?
Explain connectivity between datastage with datasources?
Differentiate between operational datastage (ods) and data warehouse?
Name the third party tools that can be used in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the difference between server job and parallel jobs?
what is the difference between == and eq in UNIX shell scripting?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the difference between account and directory options ?
Why do we use link partitioner and link collector in 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?
