table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answer Posted / 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 |
Post New Answer View All Answers
What is the importance of the exception activity in datastage?
How a source file is populated?
What are the features of datastage flow designer?
Why do we use exception activity in Datastage?
AGGREGATOR default datatype
What are the different options associated with dsjob command?
How to convert RGB Value to Hexadecimal values in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are some prerequisites for datastage?
project Steps,hits, Project level HArd things,Solved methods?
Can you explain tagbatch restructure operator?
Explain entity, attribute and relationship in datastage?
What are the various kinds of the hash file?
What are stage variables, derivations and constants?
Can you explain repository tables in datastage?