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
Slowly changing dimensions, types and where will you use them
What are the new features of informatica 9.x in developer level?
Enlist the differences between database and data warehouse.
What are the tuning techniques you applied during your last project
What is the fact table?
How to create the source and target database connections in server manager?
On which transformations you created partitions in your project?
How to join three sources using joiner? Explain though mapping flow.
What are the tasks that can be performed using sq?
Explain sessions. Explain how batches are used to combine executions?
What is the scenario which compels informatica server to reject files?
How do you set a varible in incremental aggregation
What differs when we choose the sorted input for aggregator transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the benefit of session partitioning?