Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for starflake schema ?
- 6 Answers
- 19759 Views
- TCS, I also Faced
- E-Mail Answers
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
What is meant by a domain?
What is a joiner transformation and why it is an active one?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
To import the flat file definition into the designer where should the flat file be placed?
When do you use sql override in a lookup transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to update a particular record in target with out running whole workflow?
How do you use reject loader.
In warehouses how many schemas are there?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is decode in static cache?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the types of schemas we have in data warehouse.
What is substr in informatica?
What is workflow manager?
