Interested to Buy Any Domain ? << Click Here >> for more details...
In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 15933 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 is the purpose of pivot stage and types of containers in datastage
what is the use of materialized view?
How to reverse the string using SQL?
What are the steps needed to create a simple basic datastage job?
Which warehouse using in your datawarehouse
Demonstrate experience in maintaining quality process standards?
What are the benefits of datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are sequencers?
How can we improve performance of data stage jobs?
Notification Activity
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the different kinds of views available in a datastage director?
Why fact table is in normal form?
Differentiate between datastage and informatica?
