What are the different types of schemas?
- 11 Answers
- 83101 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / giri
Schema is structure of information
1.STAR SCHEMA
-------------
Centralized Fact table connect the one or more denormalized data
2.SNOW FLAKE SCHEMA
-------------------
Centralized Fact table connect the one or more normalized data
3.STAR FLAKE SCHEMA
-------------------
One or more centralized fact table connect the single denormolized data
| Is This Answer Correct ? | 28 Yes | 23 No |
Post New Answer View All Answers
What is the different lookup cache(s)?
What could be the possible resons of locks by user?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain what transformation and how many are there in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
How can a transformation be made reusable?
Explain the features of connected and unconnected lookup.
Which are the different editions of informatica powercenter that are available?
Why filter transformation is an active one?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is a connected transformation?
Tell me about MD5 functions in informatica
What are the performance considerations when working with aggregator transformation?
How to implement security measures using repository manager?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
