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
- 15173 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
describe the Steps to confiure a Qlogic switch
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the important features of datastage?
CHANGE CAPTURE
how to abort the job its matain duplicates?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the job parameters?
Differentiate between datastage and informatica?
How do y read Sequential file from job control?
Can you explain tagbatch restructure operator?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the functionalities of link collector?
Differentiate between odbc and drs stage?
What is the use of datastage director?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
