Informatica Interview Questions
Questions Answers Views Company eMail

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

590

How does a rank transform differ from aggregator transform functions max and min?

720

What is xml source qualifier transformation in informatica?

754

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?

825

What differs when we choose the sorted input for aggregator transformation?

600

What do you understand by term role-playing dimension?

635

What is parallel processing in informatica?

1087

What is meant by lookup transformation? Explain the types of lookup transformation?

601

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 878

WHat all joins are there in Source Qualifier?

1 1851

What all join we can perform in LOOKUP transformation?

599

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

585

Different circumstance which drives informatica server to expel records?

589

Separate from an archive server and a powerhouse?

535

Make a note of the quantity vaults made in informatica?

595


Post New Informatica Questions

Un-Answered Questions { Informatica }

Partition, what happens if the specified key range is shorter and longer

2062


Enlist the tasks for which source qualifier transformation is used.

616


Write the different tools in the workflow manager?

608


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

597


what is the -ve test case in your project.

1896






Why union transformation is an active transformation?

689


How to elaborate powercenter integration service?

690


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

666


explain abt ur project architecture?

1803


What is intricate mapping?

624


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1662


What does update strategy mean, and what are the different option of it?

629


Explain pmcmd command usage in informatica

745


Enlist the differences between database and data warehouse.

590


Which are the different editions of informatica powercenter that are available?

603