Answer Posted / anitha
1.star schema
2.snowflake schema
3.glaxy schema
| Is This Answer Correct ? | 7 Yes | 70 No |
Post New Answer View All Answers
What is the difference between dependent data warehouse and independent data warehouse?
what are relationships?
How to pivot data using informatica when you have variable amount of pivot rows?
What are loops in Datawarehousing?
What is execution plan?
What is a real-time data warehouse?
Why should we use data ware housing and how can you extract data for analysis with example?
For faster process, what we will do with the universe?
Can we start and stop single session in concurent bstch?
How to provide security in frame work manager for a query subject?
What should I have in mind when building olap solution from scratch?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What are aggregate transformation?
How to import vsam files from source to target. Do we need a special plugin?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.