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
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Differentiate between Join, Merge and Lookup stage?
What are datastage sequences?
What are stage variables?
What is datastage?
What is use Array size in datastage
Explain how a source file is populated?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How you Implemented SCD Type 1 & Type 2 in your project?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How do you import and export data into datastage?
To see hidden files in LINIX?
Demonstrate experience in maintaining quality process standards?
What are the types of hashed files in data stage
What are the functionalities of link partitioner and link collector?