In which situations we can use normal and sparse lookup
stages

Answer Posted / poornachandrababu.l

When the reference is database then we will go for Sparse
look and If reference is Sequential file or DataSet then
we go for normal look up

Is This Answer Correct ?    6 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1812


What is orabulk stage?

815


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1942


in oracle target stage when we use load option and when we use upsert option?

1960


What is a merge?

841


How a routine is called in datastage job?

809


How do you import and export the datastage jobs?

922


How and where you used hash file?

857


Explain the importance of surrogate key in data warehousing?

922


How to reverse the string using unix?

3121


What are the difference types of stages?

801


What is data partitioning?

915


How can one find bugs in job sequence?

1017


What are system variables and sequencers in datastage

819


What are the main features of datastage?

890