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
What does role playing dimension mean?
What are the restrictions of union transformation?
What do think which one is the better joiner or look up?
What's the layout of parameter file (what does a parameter file contain?)?
Explain dynamic target flat file name generation in informatica
How many ways are there to create ports?
What is transformation?
How you prepared reports for OLAP?
What will be the approach?
What is the need of an ETL tool?
What is Session and Batches?
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)
What do you understand by SOA of Informatica?
Which files are created during the session rums by informatics server?
What is dimensional table? Explain the different dimensions.