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 purpose of pivot stage?
What are the types of containers in datastage?
what is use of SDR function?
Can you highlight the main features of ibm infosphere information server?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
how to export or import the jobs in .ISX file
What is orabulk stage?
What could be a data source system?
Describe link sort?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Which warehouse using in your datawarehouse
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
options available in sequence job to run,validate?