Interested to Buy Any Domain ? << Click Here >> for more details...
table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
- 9 Answers
- 15236 Views
- I also Faced
- E-Mail Answers
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 |
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is the difference between account and directory options ?
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
What are the prerequisites for join stage
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
What all are the different way to run a job?
what is repositery?
How to move data set from one server to other?what are the steps to follow to do this?
What are the areas of application?
What is size of a transaction and an array means in a datastage?
Teradata 
