Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are the components of ascential data stage?
What are datastage sequences?
What is the difference between operational data stage (ods) and data warehouse?
Define orabulk and bcp stages?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are routines in datastage? Enlist various types of routines.
What are system variables and sequencers in datastage
Can you explain players 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.
What are the different layers in the information server architecture?
What are orabulk and bcp stages?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is merge stage?
Describe the architecture of datastage?
How do y read Sequential file from job control?
