Explain the difference between oltp and olap?
What is the goal of optimizer?
What is "method/1"?
Explain how to get the first 100 rows from the flat file into the target?
Explain reference cursor?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
Explain the difference between keylokup and joiner?
What is a hash cluster?
What is conformed dimension?
What are Fact tables and Dimension Tables?
What are loops in Datawarehousing?
What is prompt types of prompts?use of prompts syntax of prompt?
Explain can report net connect multiple datasource at a time in report creation time?