Informatica Data Warehousing Question:
Download Questions PDF

Explain How many types of dimensions are available in Informatica?

Answers:

Answer #1
There r 3 types of dimensions

1.star schema

2.snowflake schema

3.glaxy schema

3 types.That are

1. SCD(slowly changing dimension) type1
2. SCD type2
3. SCD type3

Answer #2
there are 4 types
Slowly Changing dimension
Degenerated dimension
Confirmed Dimension
Junk dimension

Download Informatica Data Warehousing Interview Questions And Answers PDF

Previous QuestionNext Question
What is the difference between Informatica 7.0 and 8.0?Explain Where to store informatica rejected data? How to extract the informatica rejected data?