u can generate sequece generator for both the tables and u can use joiner

table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?

Question Posted / venky

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

Please Help Members By Posting Answers For Below Questions

What are the types of containers?

699

What are the functionalities of link collector?

633

I have a few records just I want to store data in to targets cycling way how?

1907

project Steps,hits, Project level HArd things,Solved methods?

1641

describe the Steps to confiure a Qlogic switch

1944

Can you explain players in datastage?

713

Define ds designer?

774

What is the project in datastage?

673

What is the difference between validated and compiled in the datastage?

707

Which commands are used to import and export the datastage jobs?

992

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

977

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2088

What is the method of removing duplicates, without the remove duplicate stage?

592

Can you implement SCD2 using join, transformer and funnel stage?

1097

CHANGE CAPTURE

902