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 |
What is the meaning of up gradation of repository?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
Under what condition selecting sorted input in aggregator may fail the session?
Explain target update override in informatica
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
Explain the pipeline partition with real time example?
what is the significance of newlookup port in dynamic look up
what is unique constraint error ?