| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| in which situations do u go for starflake schema ? | TCS | 5 |
| can a port in expression transf be given the name DISTINCT | | 1 |
| What is the difference between Oracle performance and
Informatica Percfomance? Which performance is better? | IBM | 2 |
| how to move the mappings from your local machine to claint
place? | | 2 |
| Can you use one mapping to populate two tables in different
schemas | | 2 |
| 1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach | Virtusa | 4 |
| What is the capacity of power cube? | | 1 |
| How will you combine 3 different sources with a single source? | | 3 |
| What is hash partition? | | 1 |
| what is confirmed dimension? | | 4 |
| what is a junk dimension ? | TCS | 5 |
| What is difference between Mapplet and reusable
transformation? | Wipro | 5 |
| what is the function of 'F10' informatica ? | IBM | 4 |
| 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 |
| What is a Shortcut and What is the difference between a
Shortcut and a Reusable Transformation? | | 1 |
| What are the different types of schemas? | ITC-Infotech | 3 |
| from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic | Deloitte | 11 |
| What is the difference between Bitmap and Btree index? | | 1 |
| What are the tasks that source qualifier performs? | | 1 |
| Which transformation should u need while using the cobol
sources as source defintions? | | 2 |
| |
| For more Informatica Interview Questions Click Here |