Which is the optimized method of extracting the data.
Answer Posted / 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 View All Answers
Can you brief about the Data warehouse project you worked on?
What is Sequence clustering algorithm?
Explain vldb?
How did you plan your Data ware house project?
How to limit the max no of rows retrieved in the report?
What is the difference between static cache and dynamic cache?
How to generate the cubes in framework manager?
How do we design a universe?
Explain what is the advantages data mining over traditional approaches?
I have two universes created by two difference database can we join them in designer & report level? How
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is mean by aggregate aware?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is data warehosuing hierarchy?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?