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
- 15181 Views
- I also Faced
- E-Mail Answers
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 are the different options associated with dsjob command?
How do you run datastage job from the command line?
Define oconv () and iconv () functions in datastage?
What are the functionalities of link partitioner and link collector?
Highlight the main features of datastage?
State the difference between an operational datastage and a data warehouse?
If you want to use a same piece of code in different jobs, how will you achieve this?
Difference between in process and inter process?
In Datastage, how you can fix the truncated data error?
How the ipc stage work?
what is ds administrator used for?
Triggers,VIEW,Procedures
which r the connectors used in san?
What could be a data source system?
What are the components of datastage?
