Answer Posted / ram
A Dimention table which can be shared by 2 or more fact
tables. for example time dimention which we can use in in
any fact table. is known as confirmed dimention
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
What are aggregate transformation?
What are session timeout and application timeout? Where we have to do this process?
What are the key columns in Fact and dimension tables?
How can we determine what records to extract?
Can any one explain the hierarchies level data warehousing.
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is a relationship?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain what is real time data-warehousing?
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?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is the difference between power center & power mart?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What is operational data store (ods)?
How to create context?