What are the different types of schemas?
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
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is domain and gateway node?
is it possible to index the data in cache of lkp transformation ?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Mention few power centre client applications with their basic purpose?
Explain sessions. Explain how batches are used to combine executions?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is workflow manager?
What you know about transaction control transformation?
What are the new features of informatica 9.x in developer level?
How do you take back up of repository?
Is it possible to define a single node as a Gateway node as well as worker node?
What is a difference between complete, stop and abort?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Whats the difference between informatica powercenter server, repositoryserver and repository?