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


Please Help Members By Posting Answers For Below Questions

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2837


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

532


Differentiate between operational datastage (ods) and data warehouse?

670


what is ds administrator used for?

716


To see hidden files in LINIX?

941






How do you reject records in a transformer?

624


Differentiate between validated and Compiled in the Datastage?

633


What is difference between server jobs & parallel jobs?

619


What are the main differences you have observed between 7.x and 8.x version of datastage?

618


What are the different options associated with dsjob command?

930


how to delete one row in target dataset

2584


What are the different types of lookups in datastage?

622


Whats difference betweeen operational data stage (ods) and data warehouse?

662


What is difference between symmetric multiprocessing and massive parallel processing?

648


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1693