Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149263 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
what is the custome stage in datastage? how can we impliment that one? plz tell me
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Which commands are used to import and export the datastage jobs?
How do you remove duplicate values in datastage?
What are the main features of datastage?
Differentiate between datastage and informatica?
How to manage date conversion in Datastage?
What is a merge in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
why do u need the IOS upgradation in a FC switch
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are the types of hashed files in data stage
What is the use of hoursfromtime() function in transformer stage in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
table actions available in oracle connector?
