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 5947

What is flashback table ? Advance thanks

Puma,

1476

what are the limitations of pushdown optimization technique ? Advance thanks

Puma,

3 39198

What is version control in informatica ? Advance thanks

HCL, Puma,

6 15737

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

Puma,

6 8465

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 13299

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

Puma,

1 5602

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

Puma,

1 3719

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

Puma,

4 7827

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

Puma,

2 14606

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

1 3455

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

1631

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

2 8868

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

Amdocs,

1 2570

Why we require dwh in particular projects?

Amdocs,

1 4432


Post New Informatica Questions

Un-Answered Questions { Informatica }

expain about the tune parameters?

1873


What do you understand by term role-playing dimension?

566


how tokens will generate?

1722


Explain where to store informatica rejected data? How to extract the informatica rejected data?

569


difference between repository database and repository service?

614






What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1889


Can we override a native sql query within informatica?

622


What is the Process to creating lookup transformation in informatica

574


What is difference between a gateway node and worker node?

612


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

621


How are the sources and targets definitions imported in informatica designer?

666


As union transformation gives UNION ALL output, how you will get the UNION output?

637


Have you worked with/created Parameter file

1222


Difference between Data and Index Caches?

643


what is diff b/t sorter t/r and agg have the option sorter property...

1733