table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answer Posted / 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 |
Post New Answer View All Answers
what is the custome stage in datastage? how can we impliment that one? plz tell me
Difference between data warehousing and olap?
Define Job control?
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...
Define orabulk and bcp stages?
What are the types of jobs we have in datastage?
how to implement scd2 in datastage 7.5 with lookup stage
How to find value from a column in a dataset?
What can we do with datastage director?
What is the difference between orabulk and bcp stages?
What are the steps needed to create a simple basic datastage job?
How to reverse the string using SQL?
What are the difference types of stages?
what is the use of skid in reporting?
What is the difference between hashfile and sequential file?