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 a general purpose scheduling tool?
what is query optimizer? what are different types of optimizer s supported by oracle ?
Difference between cold fusion 5 and cold fusion mx 6?
What is critical column?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What are the methodologies of data warehousing?
What is freehand sql?
What is the difference between agglomerative and divisive hierarchical clustering?
Explain what are the basic needs to join two sources in a source qualifier?
What is the difference between mapping parameter & mapping variable in data warehousing?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
What is conformed dimension?