| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| in which situations do u go for starflake schema ? | TCS | 5 |
| In mapping f.f as one src and f.f as trg,f.f as src and
oracle as trg which is fast? mean which is complete first
process | Wipro | 2 |
| What is aggregate awareness? | | 1 |
| how will you get 21 to 30 record from 50 records? | | 2 |
| which T/r we can use it mapping parmeter and mapping
variable? and which one is reusable for any mapping mapping
parmeter or mapping varibale? | Wipro | 2 |
| how do u use sequence created in oracle in informatica?
Explain with an simple example | CTS | 2 |
| What are the mapings that we use for slowly changing
dimension table? | | 2 |
| What is power play plug in? | | 1 |
| why dimenstion tables are denormalized in nature ?
| | 1 |
| Why we use lookup transformations? | | 1 |
| What are the session parameters? | | 2 |
| What are the reusable transforamtions? | | 1 |
| what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
| | 1 |
| why u go for dimensions ? | TCS | 3 |
| Explain grouped cross tab? | Accenture | 1 |
| When do we use dynamic cache and static cache in connected
and unconnected lookup transformations? | | 2 |
| What is difference between a connected look up and
unconnected look up? | | 3 |
| What is critical mapping? | | 1 |
| how can u connect client to ur informatica sever iff server
is located at different place( not local to the client) | Accenture | 2 |
| In real time scenario where can we use mapping parameters
and variables? | CSC | 3 |
| |
| For more Informatica Interview Questions Click Here |