Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 8896

What are two types of processes that informatica runs the session?

2 19460

What are the new features of the server manager in the informatica 5.0?

1 6523

What is metadata reporter?

Informatica,

1 8498

Define maping and sessions?

3 8962

Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 9212

Why we use partitioning the session in informatica?

2 14325

To achieve the session partition what r the necessary tasks u have to do?

1 6946

How the informatica server increases the session performance through partitioning the source?

1 9105

Why you use repository connectivity?

Yash Technologies,

3 8692

What are the tasks that Loadmanger process will do?

1 5712

What is DTM process?

4 21490

What are the different threads in DTM process?

1 6512

What are the data movement modes in informatcia?

1 8192

What aer the out put files that the informatica server creates during the session running?

4 19633

Post New Informatica Questions

Un-Answered Questions { Informatica }

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2799

Which transformation should we use to normalise the COBOL and relational sources?

1274

How can we improve session performance in aggregator transformation?

1159

How to do unit testing in informatica?

1229

How to improve the performance of a session using sorter transformation?

1191

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1312

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2088

What is the different lookup cache(s)?

1131

permutations of mapplet

2551

What is meant by lookup transformation?

1188

Explain what transformation and how many are there in informatica?

1034

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250

What all join we can perform in LOOKUP transformation?

1025

What is decode in static cache?

1267

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1153

For More Un-Answered { Informatica } Questions Click Here