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
- 15224 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 is use of SDR function?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Can you filter data in hashed file?
How and where you used hash file?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
On which Dimension Table you implemented SCD Type in your Project
Differentiate between Join, Merge and Lookup stage?
Distinguish between informatica & datastage. Which one would you choose and why?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the difference between hashfile and sequential file?
What is the difference between odbc and drs stage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What could be a data source system?
What is the flow of loading data into fact & dimensional tables?
Which commands are used to import and export the datastage jobs?
