what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 144743 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
If you want to use the same piece of code in different jobs, how will you achieve it?
What is job control?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the areas of application?
What is orabulk stage?
Can you highlight the main features of ibm infosphere information server?
How do you schedule or monitoring the job?
What is the difference between server job and parallel jobs?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How to convert RGB Value to Hexadecimal values in datastage?
Differentiate between datastage and datastage tx?
On which Dimension Table you implemented SCD Type in your Project
Define Data Stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
