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 |
Nls stands for what in datastage?
Describe routines in datastage? Enlist various types of routines.
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 is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
What are routines in datastage?
How rejected rows are managed in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
Can aggregator and transformer stages use to sort the data? How ?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
Define Routines and their types?