What function should we use to display the value entered or selected by a user in response to a prompt?
What is Star Schema?
What is the main difference between star and snowflake star schema? Which one is better and why?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Explain can a dimension table contains numeric values?
Explain what are components of report studio?
List any five applications of data warehouse.
What is an er diagram?
Explain me what are conformed dimensions?
Explain meta data?
What is the difference between filter and lookup transformation?
What is the difference between power center & power mart?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is the metadata extension?