In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 14154 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
Normal lookup:-
If we have 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 temporary memory(RAM).
Sparse lookup:-
If we have 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 temporary memory because
Refernce will have Huge data and for record(KEY Columns) from Source it will go to Reference Database and get the Output of it.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How do you remove duplicate values in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How to RD using transformer?
How to read multiple files using a single datastage job if files have the same metadata?
What are iconv and oconv?
What are the types of views in datastage director?
What are orabulk and bcp stages?
How do you import and export the datastage jobs?
Define ds designer?
How can we improve the performance in datastage?
Explain usage analysis in datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
