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
What is the function of look up transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain the types of transformations?
can u give example for factless fact table
Explain lookup transformation in informatica
Parameter and variable differences
What does reusable transformation mean?
What is sorter transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the different lookup cache(s)?
explain about unit testing? in real time?
Where do we use mapping variables in informatica?
How many numbers of sessions can one group in batches?
What is the need of an ETL tool?
Write the unconnected lookup syntax and how to return more than one column.