Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 87678 Views
- ITC Infotech, I also Faced
- E-Mail Answers
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
What is a stored procedure transformation?
What are the types of caches in lookup?
What is meant by lookup transformation?
Informatica settings are available in which file?
Write the program through which the records can be updated?
What is meant by LDAP users?
What does command task mean?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain lookup transformation in informatica
How to use pmcmd utility command?
What is a predefined event?
how we can load rejected record's at run time?(not through bad files)
Quickly characterize reusable change?
What is the use of target designer?
How can we use mapping variables in informatica?
