table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
- 9 Answers
- 12769 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 many types of hash files are there?
whom do you report?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are system variables and sequencers in datastage
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
how to export or import the jobs in .ISX file
Can we use target hash file as a lookup ?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are the different type of jobs in datastage?
What are the steps required to kill the job in Datastage?
What is data partitioning?
If you want to use a same piece of code in different jobs, how will you achieve this?
