Tell me the Top 10 features of oracle that supports
datawarehousing.
Answers were Sorted based on User's Feedback
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
difference between bo 6.5 and bo xi r2
What is metadata in context of a datawarehouse?
Is there any rownum object from which we can do this?
Explain datawarehousing?
What are the various file formats involved in reportnet?
What is difference between a connected look up and unconnected look up?
Explain what are the advantages data mining over traditional approaches?
How to get the first 100 rows from the flat file into the target?
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,
Explain what is the difference between view filter and report filter?