Interested to Buy Any Domain ? << Click Here >> for more details...
Which is the optimized method of extracting the data.
- 3 Answers
- 7449 Views
- I also Faced
- E-Mail Answers
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 are the fundamental elements of the data warehouse?
Explain what are the tasks that loadmanger process will do?
What are the differences between datamart vs. Reporting cube?
What is data analytics in simple terms?
Define data warehouse?
What are the different types of data warehousing?
What are the differences between star and snowflake schema?
Explain how to generate iqd file from framework manager?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What is bi?
Why fact table is in a normal form?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What are Non-additive facts?
