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

How do you take back up of repository?

703


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

1455


Can we override a native sql query within informatica?

607


How can you define user defied event?

595


What are the limitations of joiner transformation?

625






How can informatica be used for an organization?

621


can u give example for factless fact table

5471


define galaxy repository in informatica

1702


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1649


Explain target update override in informatica

610


How to do unit testing in informatica?

690


What is the need for an etl tool?

610


Define update strategy?

612


How do you change a non-reusable transformation to reusable transformation?

576


Explain sessions and how many types of sessions are there?

561