Interested to Buy Any Domain ? << Click Here >> for more details...
Which is the optimized method of extracting the data.
- 3 Answers
- 7205 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 the goal of optimizer?
What is Snow Flake Schema design in database?
Explain the hierarchies level data warehousing.
What are the various tools? Explain name a few?
What is surrogate key? Where we use it explain with example?
Explain what is analytical or analytic mean?
What is difference between model & package?
What are steps we have to follow in designing the userfriendly universe?
Where the cache files stored?
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 the different types of data warehousing?
What are the different types of join operations?
Teradata 
