what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 144822 Views
- HCL, I also Faced
- E-Mail Answers
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
Why we use surrogate key?
What can we do with datastage director?
What is the command line function to import and export the ds jobs?
What are the difference types of stages?
What are stage variables?
What are the types of containers in datastage?
What are the different layers in the information server architecture?
Difference between in process and inter process?
Difference between sequential file and data set?
describe the Steps to confiure a Qlogic switch
Name the different sorting methods in datastage.
How do y read Sequential file from job control?
what are the errors,warnings in datastage
How rejected rows are managed in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
