Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 86639 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
How can we use batches?
What are batches?
What are the designer tools for creating transformations?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Informatica settings are available in which file?
What are the tasks that can be performed using sq?
What is the benefit of partitioning a session?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain the different kinds of facts.
what is degenerated dimension?
How to generate sequence numbers without using the sequence generator transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain transaction control transformation in informatica
What do you mean by worklet?
Enlist the tasks for which source qualifier transformation is used.
