in which situations do u go for snowflake schema ?
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 |
To achieve the session partition what r the necessary tasks u have to do?
Define error Threshold?
What is informatica?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
What is parallel processing in informatica?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
What do you mean by enterprise data warehousing?
what is the complex transformation you used in informatica
What do you mean by filter transformation?
How to load last 10 records of flat file in to the target?
what are the row and column separations in Flat Files
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?