Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for starflake schema ?
- 6 Answers
- 19551 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / prabakaran
when we have single or multiple facts and not bothered
about query performance.
When we dont have disk storage limitations
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What you know about transaction control transformation?
What are active transformations.
Write the different tools in the workflow manager?
Explain in detail about scd type 1 through mapping.
In warehouses how many schemas are there?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to load data in informatica ?
What are the static cache and dynamic cache in informatica?
To import the flat file definition into the designer where should the flat file be placed?
How to delete duplicate row using informatica?
Explain the types of transformations?
What are roles and groups and benefits of using them?
what is the complex transformation you used in informatica
