Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 148581 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
how to abort the job its matain duplicates?
What is the precedence of stage variables,derivations, and constraints?
What is a merge in datastage?
Can you explain link buffering?
What are sequencers?
What is the flow of loading data into fact & dimensional tables?
Does datastage support slowly changing dimensions ?
Define APT_CONFIG in Datastage?
Which algorithm you used for your hashfile?
What are some different alternative commands associated with "dsjob"?
How can we improve the performance in datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Describe the architecture of datastage?
How we can covert server job to a parallel job?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
