in which situations do u go for starflake schema ?
Answer Posted / r.lakshmi
to design a DW, starflake schema is an effective method to
process the business instead of queries. provides speedy
retrival of information than snowflake schema
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How do you load unique records into one target table and duplicate records into a different target table?
Explain about cumulative Sum or moving sum?
Enlist some properties of sessions.
Mention few advantages of router transformation over filter transformation.
draw informatica architecture 8.6 ?
What is a transaction control transformation?
What are the limitations of joiner transformation?
How to do the error handling of if ur source is flatfiles?
list out all the transformations which use cache?
Design time, run time. If you don't create parameter what will happen
What is lookup change?
can we override a native sql query within informatica? How do we do it?
How might you approve all mappings in the archive all the while?
To import the flat file definition into the designer where should the flat file be placed?