Which is the optimized method of extracting the data.
- 3 Answers
- 6209 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pratap gangula
Delta loading is a way to extract data in a optimized way. Doing the incremental load by tracking the last update date or modified date makes the ETL processing faster.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are the different types of data warehousing?
What is an OLTP (Online Transaction Processing) System?
What are the fundamental elements of the data warehouse?
What is a relationship?
What is surrogate key? Explain with examples.
How to export mappings to the production environment?
Explain er diagram?
How to stop a batch?
Explain what does level of granularity of a fact table signify?
Explain what is the metadata extension?
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do
Teradata 
