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

Informatica Interview Questions

Questions Answers Views Company eMail

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

Puma,

2 6956

What is flashback table ? Advance thanks

Puma,

1999

what are the limitations of pushdown optimization technique ? Advance thanks

Puma,

3 41390

What is version control in informatica ? Advance thanks

HCL, Puma,

6 17997

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

Puma,

6 10479

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

Puma,

1 14539

Can we write to_date(three arguments) ? Will it work ? Advance thanks

Puma,

1 6435

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

Puma,

1 4471

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

Puma,

4 9577

What is the difference between lookup override and souce qualifier override ?

Puma,

2 15722

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 4395

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2187

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 10037

What is the role of informatica in project ?Like i showed financial projects?

Amdocs,

1 3394

Why we require dwh in particular projects?

Amdocs,

1 5312

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the components of Informatica? And what is the purpose of each?

1113

While migrating the data from one environment to another environment how would you manage the connections?

1133

How to load a Dimension ? and how to load a fact table?

1468

What is flashback table ? Advance thanks

1999

Name the different lookup cache(s)?

1295

Where do we use mapping variables in informatica?

1123

Enlist few areas or real-time situations where informatica is required.

1144

In which transformation you cannot drag ports into it?

1381

What is repository manager?

1028

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2111

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1804

Explain sql transformation in script mode examples in informatica

1212

Explain sessions. Explain how batches are used to combine executions?

1081

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1114

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2075

For More Un-Answered { Informatica } Questions Click Here