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
What is a datastage job?
What are the areas of application?
What is ds designer?
How to perform incremental load in datastage?
Can you define merge?
EXPLAIN SCD
What is the use of hoursfromtime() function in transformer stage in datastage?
How do y read Sequential file from job control?
What is a merge in datastage?
I have a few records just I want to store data in to targets cycling way how?
Difference between sequential file and data set?
Why do we use exception activity in Datastage?
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 the ipc stage work?
Define data aggregation?