Explain Process flow in data warehouse??






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

Post New Answer




More Data Warehouse General Interview Questions

Difference between slicing and dicing with example?

2 Answers  


Compare and contrast aggregates & indexes

0 Answers   IBM, TCS,


What is an OLTP (Online Transaction Processing) System?

4 Answers  


Explain clustering algorithm?

0 Answers  


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

0 Answers   IBM,






What is difference between a connected look up and unconnected look up?

1 Answers  


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?

0 Answers  


How do you setup Lo-cockpit?

0 Answers  


What is the "junk dimension"? Give with examples?

8 Answers  


What is the difference between a data warehouse and a data mart?

15 Answers   ASD Lab, Apex, Bank Of America,


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,


Write a short note on data warehousing & three-Tier Warehouse architecture in detail.

1 Answers  






Categories