what is fact table?

Answer Posted / shyam

Dimension table contains the textual information to analyse
the business. It contains more number of column as compare
the less no. of rows.

There are the four types of dimention table in the
Datawarehousing.
1. Confirmed Dimension
2. Shared Dimension
3. Degenerated Dimension
4. Jun Dimension.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Design time, run time. If you don't create parameter what will happen

1428


What are the components of Informatica? And what is the purpose of each?

624


Did u used latest transformations of 8.6.0? for what?

1481


What is status code in informatica?

588


How to elaborate powercenter integration service?

652






Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

611


What is decode in informatica?

661


Differentiate between joiner and lookup transformation?

621


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1482


What is a sequence generator transformation?

579


What are the different versions of informatica?

685


Explain the pipeline partition with real time example?

656


What are the popular informatica products?

653


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2072


What is the commit type if you have a transaction control transformation in the mapping?

655