Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 86617 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 does “tail –f” command do and what is its use as an Informatica admin.
What are the different transaction levels available in transaction control transformation?
How can we use mapping variables in informatica? Where do we use them?
What is parallel processing in informatica?
Explain sessions and how many types of sessions are there?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the mapping parameters and mapping variables?
What are the uses of etl tools?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What if the source is a flat-file?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How many ways a relational source definition can be updated and what are they?
As union transformation gives UNION ALL output, how you will get the UNION output?
How to load data in informatica ?
What is informatica? Why do we need it?
