When the reference is database then we will go for Sparse look and If re

In which situations we can use normal and sparse lookup
stages

Question Posted / poornachandrababu.l

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

Please Help Members By Posting Answers For Below Questions

how to export or import the jobs in .ISX file

1203

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3794

What is the difference between operational data stage (ods) and data warehouse?

1242

Which warehouse using in your datawarehouse

2185

What is apt_config in datastage?

1139

Highlight the main features of datastage?

1160

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

2186

What are the different plug-ins stages used in your projects?

1078

What is the difference between server job and parallel jobs?

1154

Describe the architecture of datastage?

1010

What all are the different way to run a job?

1094

how do u catch bad rows from OCI stage? And what CLI stands for?

2800

CHANGE CAPTURE

1300

root tree will find which is server job and which is parallel job?

1967

what is the difference between == and eq in UNIX shell scripting?

1500