Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for snowflake schema ?
- 2 Answers
- 8383 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 |
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
how remove 1st 3 records & last 3 records in informatics
What are the designer tools for creating tranformations?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
can session assigned multiple mappings or not?
How are the sources and targets definitions imported in informatica designer?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
what is diff between IN and EXIT commands
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
Which transformation is needed while using the Cobol sources as source definitions?
Teradata 
