table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answer Posted / arshad basha
hi... if the meta data are same in both tables we can go for funnel stage.If atleast one column is same in both tables we can go for merge and join stage and ofcourse can use look up.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What are transforms and what is the differenece between routines and transforms?
What are the types of containers and how to create them?
Differentiate between data file and descriptor file?
Enlist various types of routines in datastage.
Can you define merge?
Is the value of staging variable stored temporarily or permanently?
client know skid info?
How you can fix the truncated data error in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the difference between account and directory options ?
Define orabulk and bcp stages?
Difference between sequential file and data set?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
how to implement scd2 in datastage 7.5 with lookup stage
Name the third party tools that can be used in datastage?