table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answer Posted / naresh
IF the metadata is same then we can do this by using funnel
stage.
If the metadata is dirrerent then we can do this by using
join,lookup,merge stages
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
What steps should be taken to improve Datastage jobs?
how to sort two columns in single job in datastage.
what is the use of skid in reporting?
What are the repository tables in datastage?
Differentiate between datastage and informatica?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
what is ds administrator used for?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How to RD using transformer?
What are the functionalities of link partitioner and link collector?
What are datastage sequences?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the difference types of stages?
What is job control?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?