Informatica Interview Questions
Questions Answers Views Company eMail

What are the settings that you use to configure the joiner transformation?

Informatica,

617

How to load the data from a flat file into the target where the source flat file name changes daily?

Informatica,

582

Explain target update override in informatica

Informatica,

635

how to create user defined function (udf) in informatica

Informatica,

788

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

Informatica,

789

What is the difference between stop and abort in informatica

Informatica,

666

Explain constraint based loading in informatica

Informatica,

663

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

Informatica,

653

What are active and passive transformations?

Informatica,

654

What is InformaticaPowerCenter?

Informatica,

694

What are the designer tools for creating transformations?

Informatica,

687

In which transformation you cannot drag ports into it?

Informatica,

795

What are the different transaction levels available in transaction control transformation?

Informatica,

681

What is the difference between Active and Passive transformation?

Informatica,

640

How to convert multiple rows to single row (multiple columns) in informatica

Informatica,

901


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is xml source qualifier transformation in informatica?

718


Describe data concatenation?

578


What is intricate mapping?

594


Explain joiner transformation in informatica

672


State the limitations where we cannot use joiner in the mapping pipeline?

553






What is the use of an aggregator cache file?

693


Explain the difference between mapping parameter and mapping variable?

608


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

656


How is union transformation utilized?

574


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055


explain one complex mapping with logic? sales project?

6154


What do you mean by blocking transformation?

587


Briefly define reusable transformation?

631


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

1748


What is informatica metadata and where is it stored?

592