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 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.
Nls stands for what in datastage?
what is flow of project?
Define orabulk and bcp stages?
What is the purpose of pivot stage and types of containers in datastage
What is the difference between datastage and informatica?
On which Dimension Table you implemented SCD Type in your Project
Define ds designer?
How you can fix the truncated data error in datastage?
What is the command line function to import and export the ds jobs?
Can you highlight the main features of ibm infosphere information server?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is aggtorec restructure operator?
What are the various kinds of containers available in datastage?
Define Job control?
