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 6759

What is flashback table ? Advance thanks

Puma,

1888

what are the limitations of pushdown optimization technique ? Advance thanks

Puma,

3 41025

What is version control in informatica ? Advance thanks

HCL, Puma,

6 17612

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

Puma,

6 10100

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 14338

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

Puma,

1 6231

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

Puma,

1 4333

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

Puma,

4 9254

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

Puma,

2 15495

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

1 4213

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

2071

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

2 9823

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

Amdocs,

1 3245

Why we require dwh in particular projects?

Amdocs,

1 5144

Post New Informatica Questions

Un-Answered Questions { Informatica }

How can you generate reports in informatica?

992

Could you explain what is enterprise data warehouse?

1077

Mention few advantages of router transformation over filter transformation.

994

What is Cognos script editor?

4182

Explain incremental aggregation in informatica

1089

Performance tuning( what you did in performance tuning)

1929

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1998

Separate from a database, an information bazaar, and an information stockroom?

1036

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1116

without table how to come first record only in oracle?

2218

Explain about cumulative Sum or moving sum?

995

How can we improve session performance in aggregator transformation?

1060

generate date / time dimension in informatica

1084

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1026

What are the advantages of using informatica as an etl tool over teradata?

991

For More Un-Answered { Informatica } Questions Click Here