in which situations do u go for starflake schema ?
Answer Posted / vidyanand
Mostly preferable is Star schema where query performance
will be high comparing to snowflake Schema.
Snowflake schema is used only where performance issue will
not come into matter.
So, better to use star schema rather than snowflake schema.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How does the aggregator transformation handle null values?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is a filter transformation?
Enlist the advantages of informatica.
What is a passive transformation?
Explain transaction control transformation in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How do you load alternate records into different tables through mapping flow?
How can we delete duplicate rows from flat files?
How we can create indexes after completing the load process?
What is depict expression change?
What is sequence generator transformation in informatica?
Define the various join types of joiner transformation?
Differentiate between source qualifier and filter transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do