What are the different types of schemas?
Answer Posted / vignesh muralidharan
three types of schemas are availble.Star schema,star flake
schema & snow flake schema.
Star schema:It is highly denormalised,so we can retrieve
the data very fast.
Star flake schema:Only one dimension contain one level of
hierachy key.
Snow flake schema:It is highly normalised,so retrievel of
data is slow.
| Is This Answer Correct ? | 34 Yes | 43 No |
Post New Answer View All Answers
Global and Local shortcuts. Advantages.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Explain the mapping variable usage example in informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the function of aggregator transformation?
Why sorter is an active transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the components of the workflow manager?
what is the difference between informatica6.1 and infomatica7.1
How to create Target definition for flat files?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are the different transaction levels available in transaction control transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
define galaxy repository in informatica