Explain Process flow in data warehouse??
Answer / parvar
1 Source to Staging Area
2 Staging area to work space
3 Work Space to data ware house
|Is This Answer Correct ?||2 Yes||0 No|
Difference between slicing and dicing with example?
Compare and contrast aggregates & indexes
What is an OLTP (Online Transaction Processing) System?
Explain clustering algorithm?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
What is difference between a connected look up and unconnected look up?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
How do you setup Lo-cockpit?
What is the "junk dimension"? Give with examples?
What is the difference between a data warehouse and a data mart?
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 ---
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.