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

What is a datastage job?

616


What are the areas of application?

658


What is ds designer?

650


How to perform incremental load in datastage?

664


Can you define merge?

666






EXPLAIN SCD

960


What is the use of hoursfromtime() function in transformer stage in datastage?

581


How do y read Sequential file from job control?

14402


What is a merge in datastage?

765


I have a few records just I want to store data in to targets cycling way how?

1895


Difference between sequential file and data set?

641


Why do we use exception activity in Datastage?

710


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

1031


How the ipc stage work?

670


Define data aggregation?

664