Answer Posted / naresh
Sparce Lookup : if u use normal lookup it takes the entire
table into memory and perform lookup..coming to sparce
lookup it directly perform the lookup in database level.
one more difference is we can update the data into reference
tables.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
How to find value from a column in a dataset?
Difference between sequential file and data set?
Differentiate between datastage and informatica?
How we can covert server job to a parallel job?
What is use Array size in datastage
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Can you explain players in datastage?
What can we do with datastage director?
How many Key we can define in remove duplicate stage?
how to sort two columns in single job in datastage.
What is ibm datastage flow designer?
How do you generate sequence number in datastage?
What all are the different way to run a job?
Name the third party tools that can be used in datastage?
What are the functionalities of link collector?