Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149013 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
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the difference between server job and parallel jobs?
whom do you report?
What are the types of views in datastage director?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is apt_config in datastage?
Why we use surrogate key?
Define data aggregation?
how do u catch bad rows from OCI stage? And what CLI stands for?
Can you implement SCD2 using join, transformer and funnel stage?
Why do we use exception activity in Datastage?
Define Job control?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
