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
What are the main differences you have observed between 7.x and 8.x version of datastage?
Define data aggregation?
What are the different type of jobs in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What are sequencers?
What are the difference types of stages?
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
root tree will find which is server job and which is parallel job?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the different type of jobs in datastage?
What are the various kinds of containers available in datastage?
How to RD using transformer?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are the benefits of datastage?
State the difference between an operational datastage and a data warehouse?