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?

540

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

653

What is xml source qualifier transformation in informatica?

700

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?

771

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

554

What do you understand by term role-playing dimension?

556

What is parallel processing in informatica?

1007

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

551

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

1 793

WHat all joins are there in Source Qualifier?

1 1745

What all join we can perform in LOOKUP transformation?

546

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

540

Different circumstance which drives informatica server to expel records?

541

Separate from an archive server and a powerhouse?

477

Make a note of the quantity vaults made in informatica?

539


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the performance considerations when working with aggregator transformation?

662


How can we remove the duplicates from flat file source?

560


Where are the source flat files kept before running the session?

606


What is status code in informatica?

566


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1540






Explain what are the different types of transformation available in informatica.

553


What are the differences between oltp and olap?

535


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

1727


Enterprise data warehouse your projects phase by phase explain?

1439


Briefly describe lookup transformation?

587


Explain scd type 3 through mapping.

567


Is it possible to define a single node as a Gateway node as well as worker node?

635


What are the components of workflow manager?

573


Explain the difference between a data warehouse and a data mart?

583


What are the transformations that are not supported in mapplet?

585