what is fact and what types of fact tables is there

Question Posted / ahalya inturi

4 Answers
11019 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is fact and what types of fact tables is there..

Fact:
Fact represents business measure.
Fact table:
A fact table is the primary table in a dimensional model where the numerical performance measurements of the are stored.

Is This Answer Correct ?

6 Yes

0 No

what is fact and what types of fact tables is there..

Answer / pawan

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

what is fact and what types of fact tables is there..

Answer / chandrasekar

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

what is fact and what types of fact tables is there..

Answer / mural

i need example plz explain

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

How to eliminate duplicates from flat file..what is the procedure

4 Answers

Describe data concatenation?

0 Answers

What is rank transform?

0 Answers

What is the sql query overwrite in source qualifier in informatica

0 Answers Informatica,

how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers Keane India Ltd,

What is flashback table ? Advance thanks

0 Answers Puma,

How to load a Dimension ? and how to load a fact table?

0 Answers

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers HP,

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers CSC,

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers Polaris,

What is difference between Mapplet and reusable transformation?

9 Answers Wipro,

Could you explain what is enterprise data warehouse?

0 Answers

For more Informatica Interview Questions Click Here