Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149261 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 are constraints and derivations?
Differentiate between data file and descriptor file?
How do you schedule or monitoring the job?
Why we use surrogate key?
Where do you see different stages in the designer?
Explain the importance of surrogate key in data warehousing?
How to reverse the string using unix?
What are the various kinds of the hash file?
What are the different types of lookups in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Is possible to create skid in dim,fact tables?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How to perform incremental load in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
