| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what are cost based and rule based approaches and what is
the difference?
| | 1 |
| If we have lookup table in workflow how do you trouble
shhot to increase performance? | | 2 |
| wat s mapping parameter and mapping variable? how do you
set that in a mapping? | | 2 |
| what are the real time problems generally come up while
doing or running mapping or any transformation? | | 2 |
| What is the difference between view and materialised view? | | 4 |
| What is Factless fact table ??? | | 6 |
| How can you define a transformation? What are different
types of transformations in Informatica? | | 4 |
| What is the Hierarchy of DWH? | | 1 |
| whether Sequence generater T/r uses Caches? then what type
of Cache it is | Accenture | 3 |
| .prm wirh repalce .txt is possible? | | 2 |
| What is difference between Mapplet and reusable
transformation? | Wipro | 5 |
| What is IQD file?
| | 1 |
| WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED
FOR INSERT , UPDATE OPRATION ? | Oracle | 3 |
| how to obtain performance data for individual
transformations. | | 2 |
| Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse | TCS | 4 |
| What are the different threads in DTM process? | | 2 |
| Can you start a session inside a batch individually? | | 1 |
| what is the difference between lookupoveride and joiner? | | 2 |
| in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ? | Target | 7 |
| S1 is having 1 lakh records and s2 is having 100 records,
s2 should compare s1 if emp no is same data should be
updated if not their it should insert the data.what are the
transformation used? | TCS | 1 |
| |
| For more Informatica Interview Questions Click Here |