Which is the optimized method of extracting the data.
Answers were Sorted based on User's Feedback
Answer / pratap gangula
Delta loading is a way to extract data in a optimized way. Doing the incremental load by tracking the last update date or modified date makes the ETL processing faster.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / aswin
break-down the data into small chunks and try to process it...if it flatfile use unix to split the file
if it is oracle, use external table concept and load it into partitioned table using swap partition
| Is This Answer Correct ? | 0 Yes | 0 No |
if source contain 10records how you identify header and footer
Start a batches with in a batch?
Explain which are the olap tools available that are supported by oracle?
Why is business intelligence (bi) important in data warehousing?
What is a Data Cube?
How can we run the graph?
What is DTS ?
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends
Explain what are the methodologies of data warehousing?
what is the difference between aggregate table and fact table ? how do you load these two tables ?
Explain why denormalization is promoted in universe designing?
What are different stages of ?Data mining??