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 IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is InformaticaPowerCenter?
Do you find any difficulty while working with flat files as source and target?
Target increases every day even though no new record was inserted
What is sequence generator transformation in informatica?
what is the complex transformation you used in informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Repository user profiles
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Briefly define reusable transformation?
can we override a native sql query within informatica? How do we do it?
What is source qualifier transformation in informatica?