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 many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

what is fact table?

9 Answers  

How union transformation is used?

0 Answers  

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

Is it possible to revert a global repository to local one and why?

0 Answers  

What is active and passive transformation?

10 Answers  

What are the types of lookup transformation?

0 Answers   Informatica,

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

For more Informatica Interview Questions Click Here
Categories