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 6850

What is flashback table ? Advance thanks

Puma,

1934

what are the limitations of pushdown optimization technique ? Advance thanks

Puma,

3 41204

What is version control in informatica ? Advance thanks

HCL, Puma,

6 17779

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

Puma,

6 10288

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 14428

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

Puma,

1 6329

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

Puma,

1 4393

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

Puma,

4 9396

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

Puma,

2 15600

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

1 4298

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

2120

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

2 9917

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

Amdocs,

1 3305

Why we require dwh in particular projects?

Amdocs,

1 5230

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the features of connected and unconnected lookup.

935

Difference between Target-based loading and constraint-based loading?

1000

What are the components of workflow manager?

1096

How to extract the informatica rejected data?

1220

What is workflow monitor?

1062

Explain the types of lookup transformation?

1045

How can we create index after completion of load process?

1125

Explain the different kinds of facts.

981

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2075

Which development components of informatica have the highest usage?

1043

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

2120

Performance tuning in UNIX for informatica mappings?

2568

Enlist the differences between database and data warehouse.

1120

What is the status code in stored procedure transformation?

1182

How can we update a record in the target table without using update strategy?

1148

For More Un-Answered { Informatica } Questions Click Here