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

Informatica Interview Questions

Questions Answers Views Company eMail

What are the two modes of datamovement in informatica sever?

2 7097

What is confirmed dimension and fact?

7 19936

What are reusable transformations in how many ways we can create them?

2 9450

What is facttable granularity?

2 8382

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

HeadStrong, TCS,

8 31490

What are the different types of schemas?

ITC Infotech,

11 87692

How to enter same record twice in the target table,explain?

7 14243

What are the different threads in DTM process?

2 10005

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 12893

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 35649

what are presession,postsession success and postsession failure commands ?

1 6872

What are mapping parametres and variables in informatica?

TCS,

6 35894

What is source qualifier?

SDS,

6 31915

What is the Difference between DSS & OLTP?

5 12951

Explain grouped cross tab?

Accenture,

1 14502

Post New Informatica Questions

Un-Answered Questions { Informatica }

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2410

Is it possible to revert a global repository to local one and why?

1140

Explain joiner transformation in informatica

1174

Define mapping and session?

1093

Can informatica load heterogeneous targets from heterogeneous sources?

1238

How to update or delete the rows in a target, which do not have key fields?

1226

explan ur project architecture?

2129

I have a flat file, want to reverse the contents of the flat file

1174

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7597

How does the aggregator transformation handle null values?

1197

tell me 5 session failure in real time how can you solve that in your project?

2396

How many transformations can be used in mapplets.

1984

What are the tasks that source qualifier perform?

1145

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1680

What is an Integration service in Informatica?

1194

For More Un-Answered { Informatica } Questions Click Here