Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 148589 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rahul
all the three stages are differ with each other mainly
depends on three categories
1)input column requirements
a) sorting
b)de duplication
2)treatment of unmatched data
3)memory usage
1.. sorting in joins and merge in primary table and
secondary table is mandatory where in look up its optional.
de duplication in joins its allowed no warnings and no
job aborts.
in case of look up in primary table its accepted but in
secondary it raises warnings.
in merge primary table raises warnings in secondary
table its accepted.
about treatment of unmatched data and about memory discussed
above by some one..
thank you
| Is This Answer Correct ? | 19 Yes | 7 No |
Post New Answer View All Answers
Define oconv () and iconv () functions in datastage?
what is flow of project?
how to sort two columns in single job in datastage.
What are the primary usages of datastage tool?
What are the features of datastage flow designer?
What is the different type of jobs in datastage?
How can you write parallel routines in datastage PX?
what is the use of skid in reporting?
What is the command line function to import and export the ds jobs?
Differentiate between data file and descriptor file?
what is 'reconsideration error' and how can i respond to this error and how to debug this
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the purpose of interprocessor stage in server jobs?
What is aggtorec restructure operator?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
