Explain what is ods (operation data source)?
No Answer is Posted For this Question
Be the First to Post Answer
What are the advantages and disadvantages of reporting directly against the database?
What is conformed dimension?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is the difference between junk dimension and degenerated dimension?
Where do we use semi and non additive facts?
Where the cache files stored?
What is difference between a connected look up and unconnected look up?
Explain when do we analyze the tables? How do we do it?
How to drill through from a powerplay cube to reportnet?
Explain what is difference between query studio and report studio?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,