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 |
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What is metadata in context of a datawarehouse?
What is a look up function? What is default transformation for the look up function?
Can we take backup when the database is opened?
What is the data type of the surrogate key?
Explain what are the various transformation available?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is vldb(very large databases)?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Explain what are the steps to build the data warehouse?
What is the use of dimensional modeling in data warehousing?
What are aggregate fact tables ? why they are needed? give an example