what is the main differences between Lookup, Join and Merge
stages?
Answer Posted / venki
lookup having one input link and n intermediate links one
reference link and one optional reject link
input data in sorted order
fore types of look are there
1.normal lookup
2.sparce lookup
these two more added in 8.1
3.range lookup
4.caseless sensitive
normal lookup
while doing normal lookup frist the reference data is
loaded in to memory this is used when the reference data in
high
sparce lookup
while doing the sparce lookup first for each input record
generate a sql quarry and made the operation in datadase
only one reference link the reference link should be
database or lookup file set only no intermediate links
this is used when the reference data is in low
Is This Answer Correct ? | 11 Yes | 9 No |
Post New Answer View All Answers
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how can we create rank using datastage?what is the meaning of rank?
table actions available in oracle connector?
What is a merge?
Nls stands for what in datastage?
What are the different type of jobs in datastage?
what are the errors,warnings in datastage
What is datastage engine?
Differentiate between datastage and datastage tx?
Describe stream connector?
How can we improve the performance in datastage?
What are the functionalities of link partitioner?
Can you explain kafka connector?
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
What is meta stage?