in which situations do u go for snowflake schema ?
Answer Posted / 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 |
Post New Answer View All Answers
Informatica settings are available in which file?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is workflow manager?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
explain abt ur project architecture?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is meant by LDAP users?
If informatica has its scheduler why using third party scheduler?
list out all the transformations which use cache?
What is a pre-defined event and user-defined event?
What are the databases that informatica can connect to windows?
Define Pmrep command?
How to start a workflow using pmcmd command?
what is the -ve test case in your project.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?