Answer Posted / nitin
Fact table :- It consists of foreign Keys and MEasures(Numeric values)
Dimension :- It provides descriptive information relating to the foreign key in a fact
Eg:- in employee table i have ename empid sal
in manager table i have mname mid and sal
so there are two dimension table
1--> emp table contains enmae eid(PK) sal
2--> Mgr table contains mname mid(PK) sal
Fact table contains
eid(FK) mid(FK) esal and msal
PLease correct me if i'm wrong
Is This Answer Correct ? | 30 Yes | 6 No |
Post New Answer View All Answers
What is the difference between view filter and report filter?
Where the data cube technology is used?
What is load manager?
What a static and local variable?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
How can we run the graph? What is the procedure for that?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is the difference between aggregate table and materialized view?
Explain what is the data type of the surrogate key?
if you use oracle sql*loader , how do you transform data with it during loading?
I need a good brd and uc template?
Explain the difference between oltp and olap?
Explain what does level of granularity of a fact table signify?
What is batch processing?
What are the methodologies of data warehousing?