table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answer Posted / srinivas
u can generate surrogate key generator for both the tables
and u can use Inner join based on key column i.e surrogate
key and u can get 10 columns..
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How you Implemented SCD Type 1 & Type 2 in your project?
What are the types of containers and how to create them?
Distinguish between informatica & datastage. Which one would you choose and why?
What are the different layers in the information server architecture?
What are the types of hashed files in data stage
What is the difference between datastage and informatica?
What is a quality stage in datastage tool?
Can we use target hash file as a lookup ?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
If you want to use the same piece of code in different jobs, how will you achieve it?
Differentiate between datastage and datastage tx?
Demonstrate experience in maintaining quality process standards?
Define project in datastage?
What is the difference between operational data stage (ods) and data warehouse?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how