Answer Posted / ansari
Fact table: It contains numeric values and also contain
composite key(i.e collection of foreign key) e.g.. sales
and profit.
Dimension table: It contains character values E.g
Customer_name,Customer_city.
| Is This Answer Correct ? | 48 Yes | 79 No |
Post New Answer View All Answers
Explain a relation schema and a relation?
What are session timeout and application timeout? Where we have to do this process?
What is the difference between a primary and secondary actor in use case modeling?
How do you setup Lo-cockpit?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What are templates in which way it is help full?
Explain what is the extension of file to save template?
How can we determine what records to extract?
Explain what is the difference between view filter and report filter?
What is execution plan?
What is a core dimension?
Why facts table is useful in representing the data?
explain about balanced dimension,
Can decision tree be implemented using SQL?