Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is fact and what types of fact tables is there

Question Posted / ahalya inturi

Answers were Sorted based on User's Feedback



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

Answer / suresh

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

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

can session assigned multiple mappings or not?

2 Answers   Zensar,

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

Define informatica repository?

2 Answers   Wipro,

Can we create multiple integration service on single repository?

0 Answers  

Does an informatica transformation support only aggregate expressions?

0 Answers  

how to remove staging area

1 Answers  

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

What are the performance considerations when working with aggregator transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories