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


Please Help Members By Posting Answers For Below Questions

What is many-to-many dimensional model in datawarehousing ?

514


What is latest version of power center / power mart?

559


Explain the difference between keylokup and joiner?

507


What according to you might be the future of data warehousing?

534


What is the difference between view materialized view and view?

594






What is the function of etl when used in data warehousing?

541


What are the stages that are required in data warehousing?

520


How to handle multi value dimensions?

1788


How can you import tables from a database?

563


What is the difference between connected and unconnected stored procedures?

556


what are the other factors of the database on which the loading performance depend?

1502


Why null values are mapped as 0 in fact tables?

538


Describe the differences between a data warehouse and data mart.

509


What is partitioning? What are the types of partitioning?

578


What is edw?

631