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
Notification Activity
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
What is ds designer?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Explain how a source file is populated?
What are the different common services in datastage?
Which algorithm you used for your hashfile?
What are the components of ascential data stage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
how can we create rank using datastage?what is the meaning of rank?
How to read the length of word in unix?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How do u convert the columns to rows in datastage?
How will you move hashed file from one location to another location?
Define Routines and their types?