| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Without using Lookup & Sequence Generator, How to generate
Sequence? | | 2 |
| I have 1200 records how can u send it in aggregator with
good performance issues? | | 2 |
| in which situations do u go for starflake schema ? | TCS | 5 |
| Why we use partitioning the session in informatica? | | 1 |
| how will you remove the duplicate records from flat file
without using sorter? | | 1 |
| wt is Dynamic lookup Transformation?
when we use?how we use?
| | 2 |
| Explain about HLD and LLD ? | Accenture | 7 |
| what is the diff b/w target load plan and cbl? | | 1 |
| when we go for unconnected lookup transformation? and why? | Accenture | 3 |
| what is the function of 'F10' informatica ? | IBM | 4 |
| What is a look up function? What is default transformation
for the look up function? | | 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 will u find weather dimension table is big in size of a
fact table? | | 1 |
| Explain grouped cross tab? | Accenture | 1 |
| How to find from a source which has 10,000 records, find the
average between 500th to 600th record? | | 1 |
| how DTM buffer size and buffer block size are related | Wipro | 3 |
| What is the Router transformation? | | 1 |
| what is update strategy transformation ? | | 3 |
| What is a data modeling? | | 1 |
| What are the different types of schemas? | | 3 |
| |
| For more Informatica Interview Questions Click Here |