Interested to Buy Any Domain ? << Click Here >> for more details...
In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 15735 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nandini
Normal lookup:- U r having 90% data in primary like(source
table) and 10% data of Refference link(lookup table)in kind
of sutivation we can use normal lookup.and the normal
lookup data can stores in the temprovary memory.
Sparse lookup:-U r having 10% data in primary like(source
table) and 90% data of Refference link(lookup table)in kind
of sutivation we can use sparse lookup.and the sparse
lookup data can not stores in the temprovary memory because
it s having the huge data.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What are the types of containers?
What are routines in datastage? Enlist various types of routines.
How do you schedule or monitoring the job?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the types of containers and how to create them?
How to convert RGB Value to Hexadecimal values in datastage?
what is ds administrator used for?
Where do you see different stages in the designer?
What is the difference between orabulk and bcp stages?
What is datastage?
What are the steps required to kill the job in Datastage?
what is repositery?
What steps should be taken to improve Datastage jobs?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
