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
What is a functional dependency f said to be minimal?
Where the cache files stored?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are the other names given to data warehousing?
Is union transormation is active transformation?
How can we run the graph?
What function should we use to display the value entered or selected by a user in response to a prompt?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
what is parallel query?
What is the difference between metadata and data dictionary?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What is type 2 version dimension?
What is called data cleaning?
Can any one explain the hierarchies level data warehousing.
What is a fact, dimension, measure?