What are the different types of schemas?
Answer Posted / kalyan
3types of schems:
Star Schema (As above)
Snow Flake Schema (As above)
Galaxy or Integrated or Fact Constellation Schema ( By
which, a dimensional table is shared by one or more Fact
tables )
Good Luck.
| Is This Answer Correct ? | 40 Yes | 16 No |
Post New Answer View All Answers
In informatica workflow manager, how many repositories can be created?
What does refresh system mean, and what are its distinctive choice?
Explain sessions. Explain how batches are used to combine executions?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Differentiate between a database and data warehouse?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to load a Dimension ? and how to load a fact table?
How many input parameters can exist in an unconnected lookup?
What are batches?
What is workflow monitor?
What if the source is a flat-file?
Difference between Data and Index Caches?
what is INFORMATICA TESTING process
Where is metadata stored?