table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answer Posted / venky
u can generate sequece generator for both the tables and u
can use joiner transforation,u can get 10 columns
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Differentiate between operational datastage (ods) and data warehouse?
what is ds administrator used for?
To see hidden files in LINIX?
How do you reject records in a transformer?
Differentiate between validated and Compiled in the Datastage?
What is difference between server jobs & parallel jobs?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the different options associated with dsjob command?
how to delete one row in target dataset
What are the different types of lookups in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is difference between symmetric multiprocessing and massive parallel processing?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?