Interested to Buy Any Domain ? << Click Here >> for more details...
Which is the optimized method of extracting the data.
- 3 Answers
- 7457 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 |
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
what is the difference between MOLAP and ROLAP?
Explain what is fact less fact table? Where you have used it in your project?
Explain about Control M JObs detaily?How to execute this.
2 Answers Scope International,
in general which algorithms for used?
How can you implement many relations in star schema model?
Explain what are the tasks that loadmanger process will do?
What is the difference between Datawarehouse and OLAP?
if source contain 10records how you identify header and footer
What is the difference between olap and oltp?
what are the similarities between ROLAP and MOLAP
What is the purpose of Dataware Control?
Teradata 
