| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to delete duplicate record in Informatica? | | 4 |
| How to load time dimension? | Ford | 1 |
| what is difference between dimention table and fact table? | | 1 |
| How to update records in Target, without using Update Strategy? | | 3 |
| what is the function of 'F10' informatica ? | IBM | 4 |
| What are Dimensions and various types of Dimensions? | | 2 |
| Whatis the difference between View and Materialized View ? | Satyam | 6 |
| what are the real time problems generally come up while
doing or running mapping or any transformation? | | 2 |
| To achieve the session partition what r the necessary tasks
u have to do? | | 1 |
| Hi All,
I've 110 records in my table but 101 records contains an
error. When I run the session, I want to load the 100
records into the target. Can anyone suggest me the best
solution for this...
Thanks in Advance,
| Tech-Mahindra | 5 |
| What are the basic needs to join two sources in a source
qualifier? | | 4 |
| If the source has duplicate records as id and name columns,
values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this? | CTS | 3 |
| what are presession,postsession success and postsession
failure commands ? | | 1 |
| What is a taget load order? | IBM | 2 |
| What is the default source option for update stratgey
transformation? | | 1 |
| what is dimension table? | | 9 |
| Flat file heaving 1 lack records and I want to push 52000
records to the target? | | 6 |
| What is difference between Mapplet and reusable
transformation? | Wipro | 5 |
| Please let me know how to do estimation before staring
development in project. Here estimation in the sense how
many associates are required, etc to complete the project. | iGate | 1 |
| THREE DATE FORMATS R THERE . HOW TO CHANGE THESE THREE INTO
ONE FORMAT WITHOUT USING EXPRESSION TRANSFORMATION ? | HP | 2 |
| |
| For more Informatica Interview Questions Click Here |