Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for snowflake schema ?
- 2 Answers
- 8622 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bala
If suppose we are having the multiple Fact tables and
multiple dimension tables normalized data ; we can go for
snowflake schema.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / giri
it will used at time u will maitain normalised data u r
data having more cordinality dat tables
| Is This Answer Correct ? | 0 Yes | 0 No |
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
what are surrogate keys?
How to jion 2 tables, without using any condition?
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
What is difference between a gateway node and worker node?
Does an informatica transformation support only aggregate expressions?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
When the informatica server marks that a batch is failed?
how to create a sample mapping for dynamic lookup transformation
Explain the flow of data in Iinformatica?
What are active and passive transformations?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
Teradata 
