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 operational data store (ods)?
Explain hybrid slowly changing dimension?
Explain what are non-additive facts?
Explain the versions of reportnet?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
Explain what is ods (operation data source)?
Describe the differences between a data warehouse and data mart.
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is normalization, first normal form, second normal form, third normal form?
What are the steps of implementing data warehousing?
Code the tables statement for a single-level (most common) frequency?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain what are components of report studio?
Explain what is the difference between olap and datawarehosue?