What are situations where snowflake schema is better than star schema when the opposite is true?
What is ods (operation data source)?
What is the difference between ods and oltp?
Tell me what is full load & incremental or refresh load?
Explain what does level of granularity of a fact table signify?
What is pre-emptive and non-pre-emptive?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
Explain what is the difference between powerplay transformer and power play reports?
What is fact less fact table? Where you have used it in your project?
What is the difference between constraind base load ordering and target load plan?
How to import vsam files from source to target. Do we need a special plugin?
if you use oracle sql*loader , how do you transform data with it during loading?
What is informatica architecture?
What is load manager?
Explain what is the difference between power center & power mart?