Interested to Buy Any Domain ? << Click Here >> for more details...
Why should we use star schema in datawarehouse design?
- 2 Answers
- 6176 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / arun
Star schema has less joins within its related dimensions so query retreival is faster than SNow-flake.
Space consumed is more than snow-flake
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / jz
1) Query performance is high.
2) It consume less space compare to SnowFlake.
| Is This Answer Correct ? | 4 Yes | 6 No |
How an expression transformation differs from aggregator transformation?
with out using update strategy transnsformation how to update the data in mapping level
what are the output files that the informatica server creats during running a session?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
What is meant by pre and post session shell command?
can anyone explain me about retail domain project in informatica?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
what is incremental data aggregation?
Why we need XMLs?
In warehouses how many schemas are there?
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
Teradata 
