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 |
Explain differences between star and snowflake schemas?
Define Data Warehousing?
What is ?Data mining??
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
Explain what is type 2 version dimension?
Difference between cold fusion mx 6 and cold fusion mx 7?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
How are models actually derived?
where exactly in dataware house a confirmed dimension can be created
Explain the difference between view and materialized view?
What is surrogate key? Where we use it?
What is partitioning? What are the types of partitioning?