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,

1936

what are the limitations of pushdown optimization technique ? Advance thanks

Puma,

3 41206

What is version control in informatica ? Advance thanks

HCL, Puma,

6 17781

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 3306

Why we require dwh in particular projects?

Amdocs,

1 5230

Post New Informatica Questions

Un-Answered Questions { Informatica }

Define pmcmd command?

1043

What is workflow manager?

1048

How does a sorter cache works?

1070

How can we improve session performance in aggregator transformation?

1117

list out all the transformations which use cache?

1184

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1581

How are indexes created after completing the load process?

1644

difference between informatica 8.1.1 and 8.6

3677

what is the difference between informatica6.1 and infomatica7.1

2277

What is the use of transformation?

998

What are the uses of etl tools?

1128

What is sequence generator transformation in informatica?

1079

Briefly explain the aggregator transformation?

1008

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1902

During the running session, output files are created by informatica server. Enlist few of them.

982

For More Un-Answered { Informatica } Questions Click Here