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


Please Help Members By Posting Answers For Below Questions

What does role playing dimension mean?

623


What are the restrictions of union transformation?

576


What do think which one is the better joiner or look up?

724


What's the layout of parameter file (what does a parameter file contain?)?

1915


Explain dynamic target flat file name generation in informatica

647






How many ways are there to create ports?

725


What is transformation?

657


How you prepared reports for OLAP?

1151


What will be the approach?

577


What is the need of an ETL tool?

640


What is Session and Batches?

662


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1077


What do you understand by SOA of Informatica?

585


Which files are created during the session rums by informatics server?

705


What is dimensional table? Explain the different dimensions.

655