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 |
What is META DATA information in Data warehousing projects?
What are the stages that are required in data warehousing?
What according to you might be the future of data warehousing?
Explain which columns go to the fact table and which columns go the dimension table?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is aggregate awareness?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Explain grouped cross tab?
Explain what is a view as it relates to system modeling?
what is difference between drill & scope of analysis?
After the complete generation of a report who will test the report and who will analyze it?