What is XMLA ?
Explain differences between star and snowflake schemas?
Name a few sectors which use data warehousing?
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 to know the time taken for particular report execution?
What is Bulk Insert?
Explain what is the difference between olap and datawarehosue?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain the main differences between star and snowflake schema?
Explain dimension table ?
Explain a relation schema and a relation?
What is the difference between mapping parameter & mapping variable in data warehousing?
Where the applications and where ware house management system is used?