Which is the optimized method of extracting the data.
Answer Posted / 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 |
Post New Answer View All Answers
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
How can we load the time dimension?
What is the difference between agglomerative and divisive hierarchical clustering?
What is a functional dependency f said to be minimal?
What is data validation strategies for data mart v?
What is load manager?
How can you communicate with web server (apache or iis) from coldfusion?
Explain where do we use semi and non additive facts?
What should I have in mind when building olap solution from scratch?
How to pivot row data using informatica?
how much memory space occupied real time project (roughly)?
Explain degenerate dimension table?
What is real-time datawarehousing?
What are session timeout and application timeout?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?