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
How many areas for files does datastage have?
how to add a new records into source?
What is the project in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Can you explain kafka connector?
What are data elements?
Explain the importance of surrogate key in data warehousing?
Why do you need stage variables?
What is the use of datastage director?
what are the errors,warnings in datastage
Differentiate between validated and Compiled in the Datastage?
Can we use target hash file as a lookup ?
What are the different types of lookups in datastage?
in oracle target stage when we use load option and when we use upsert option?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
