Interested to Buy Any Domain ? << Click Here >> for more details...
Which is the optimized method of extracting the data.
- 3 Answers
- 7199 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 ?Data Warehousing??
Explain a linked cube?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain what is difference between query studio and report studio?
capital of tamilnadu
What is a data warehousing?
Explain meta data?
What is a data profile?
Compare and contrast aggregates & indexes
What is the difference between olap and oltp?
What are non-additive facts in detail?
Teradata 
