Which is the optimized method of extracting the data.

Answers were Sorted based on User's Feedback



Which is the optimized method of extracting the data...

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

Which is the optimized method of extracting the data...

Answer / swathi

by filtering the data

Is This Answer Correct ?    0 Yes 0 No

Which is the optimized method of extracting the data...

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

Post New Answer

More Data Warehouse General Interview Questions

Explain what is the difference between stop and abort?

0 Answers  


What is the difference between view materialized view and view?

0 Answers  


Why is dimensional normalization not required?

0 Answers  


What Oracle features can be used to optimize my Warehouse system?

1 Answers  


What is source qualifier?

2 Answers  






I have two universes created by two difference database can we join them in designer & report level? How

0 Answers  


Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

0 Answers  


Can we have multiple application.cfm file in an application?

0 Answers  


Hi Cognos Folks, I have all cognos certification dumps. In fact i am certified in most of the dumps recently. I have cognos material, pdfs, user guides, documents along with dumps. If any one required cognos dumps, please drop me mail at cognos.biuser@gmail.com Thanks, Cognos bi user

13 Answers   IBM,


can anybody mail me the FAQS for hyperion essbase amd planning

0 Answers   DataMonitor,


After the generation of a report to whom we have to deploy or what we do after the completion of a report?

0 Answers  


What is the use of tabular model, tabular sql, tabular reference in real time application?

0 Answers  


Categories