what is fact and what types of fact tables is there
Answers were Sorted based on User's Feedback
Fact: It is an object that is being analyzed.
Fact table: It consists of a composite key and facts, where ever attribute of the composite key is a foreign key to the dimension table or summarized information.
Two Types Of Fact Tables:
1) Cumulative Fact Table: Describes what was happened over the period of time. They contain addition facts.
2) Snap shot Fact Table: Deals with the particular period time. They contain non-additive and semi-additive facts.
Is This Answer Correct ? | 3 Yes | 0 No |
A Fact table contains unique combination of dimensional keys.
Fact tables are normalized.
A Fact tables have the facts at the lowest level of granularity.
Types of Fact table:
There are 3 types .
1)Detailed Fact table
2)Aggregate/Summarize fact table
3)Factless fact table
If it wrong means please send the correct answer to me
chandranmca2007@gmail.com
Is This Answer Correct ? | 1 Yes | 0 No |
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
Performance tuning in UNIX for informatica mappings?
What are the mapings that we use for slowly changing dimension table?
What is native users?
What is an unconnected transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
How to use procedural logic inside infromatica?
All active transformations r passive or not?
how do u move the code from development to production?
How to retrieve last two days updated records?