Interested to Buy Any Domain ? << Click Here >> for more details...
Which is the optimized method of extracting the data.
- 3 Answers
- 7355 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 |
When should you use a STAR and when a SNOW-FLAKE schema?
Explain a linked cube?
What is a source qualifier?
What are data modeling and data mining? Where it will be used?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
What is the metadata extension?
what is user variable in affinium campaign? and some real time examples.
What is data warehosuing hierarchy?
What is the working process for application.cfm?
What is Analysis Services?
What is Bulk Insert?
Explain what are the advantages of query studio compared to report studio?
Teradata 
