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
List down some of the real time data-warehousing tools?
What is the difference between ods and oltp?
What according to you might be the future of data warehousing?
Fact table is in normalized or de-normalized form?
What is the difference between snowflake and star schema?
What are the advantages and disadvantages of reporting directly against the database?
Explain reference cursor?
What is a functional dependency f said to be minimal?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Do you view contain data?
Explain why should you put your data warehouse on a different system than your oltp system?
What is load manager?
How much data hold in one universe.
Why is chameleon method used in data warehouse?
How to limit the max no of rows retrieved in the report?