⟩ Explain How many types of dimensions are available in Informatica?
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
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
How many types of facts and what are they?
Whats the diff between Informatica powercenter server, repositoryserver and repository?
What is the difference between Narmal load and Bulk load?
What is Load Manager?
What are partition points?
What are the advantages of dataset compare to fileset?
Is it possible to see the data in dataset?
What are the nulls on microstrategy report and how to mask them?
How to increase logical sige of a table in microstrategy?
What is the difference b/w the public object&schema object?