Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 46816 Views
- I also Faced
- E-Mail Answers
Answer Posted / hania
Star Schama : easy for users to understand, optimize navigation and more suitable for query processing, and works faster.
Disadvantages: Dimension table have greater rows, large fact table
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Define the various join types of joiner transformation?
Explain sql transformation in script mode examples in informatica
Clarify the utilization of aggregator cache record?
What are the advantages of informatica?
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
Different circumstance which drives informatica server to expel records?
How do you change a non-reusable transformation to reusable transformation?
Which is the t/r that builts only single cache memory?
What is a passive transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the different kinds of facts.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the different lookup cache(s)?
What is rank index in rank transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
