What are the mapping paramaters and maping variables?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is surrogate key? Where we use it? Explain with examples.
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
State any 5 of Cods guidelines of an OLAP system, brief description each?
What is Active Datawarehousing?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Why is dimensional normalization not required?
What is ods (operation data source)?
How to define a cube??
DWH architecture?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain what are components of reportnet?