table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answers were Sorted based on User's Feedback
Answer / ramachandra rao.pinninty
In both tables having any common key column use join
stage,other wise in both the tables any columns having same
data type and data length use lookup otherwise that means
there is no common key column,and data length,types are not
same using surrogate key or column generator in both the
tables use join stage.in target it dispaly's 10 fields.
NOTE:the question was little bit clumbsy(there is no clarity)
so these are the way's to solve the senario.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / srinivas
u can generate surrogate key generator for both the tables
and u can use Inner join based on key column i.e surrogate
key and u can get 10 columns..
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / rajesh.dwh
To do this in server job: use merge stage/transformer stage
to join these two tables (Ta and Tb) mapping them and load
it into target (sequential/ODBC/ORACLE) etc.
To do this in parallel job: use merge/joiner stage and do
above task.
thanks & regards:
todbarajesh@gmail.com
Is This Answer Correct ? | 2 Yes | 4 No |
Answer / akhi
It is Simple in join stage fullouterjoin technique we get
all 10 coloumns
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / 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 |
Answer / vinay kumar
IF THE TABLE A HAVING STRUCTURE,TABLE B HAVING SAME
STRUCTURE LIKE TABLE A WE CAN GO THROUGH AS FUNNEL STAGE.
Is This Answer Correct ? | 1 Yes | 10 No |
What are the different database update actions available?
convert yyyy mm dd to dd mm yyyy?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How and where you used hash file?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,
What is the different type of jobs in datastage?
What are the different options associated with dsjob command?
How to remove blank spaces from data?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
How do you generate sequence number in datastage?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?