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
- 14881 Views
- I also Faced
- E-Mail Answers
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
Which commands are used to import and export the datastage jobs?
What are routines in datastage?
Name the different types of Lookups in Datastage?
In Datastage, how you can fix the truncated data error?
Does datastage support slowly changing dimensions ?
Explain ibm infosphere information server and highlight its main features?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the benefits of datastage?
EXPLAIN SCD
Demonstrate experience in maintaining quality process standards?
Can you explain tagbatch restructure operator?
Name the different sorting methods in datastage.
What is datastage engine?
What are the different options associated with dsjob command?
What is the use of hoursfromtime() function in transformer stage in datastage?
