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

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

what is Active lock explain

0 Answers   Satyam,

what is the gap analysis?

1 Answers  

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

How do you load alternate records into different tables through mapping flow?

0 Answers  

What is an unconnected transformation?

0 Answers   Informatica,

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

What are the new features of informatica 9.x at the developer level?

0 Answers  

For more Informatica Interview Questions Click Here
Categories