Informatica Interview Questions
Questions Answers Views Company eMail

What are pre and post-session shell commands?

745

How does the aggregator transformation handle null values?

703

What are the performance considerations when working with aggregator transformation?

678

When do you use sql override in a lookup transformation?

591

How does a sorter cache works?

573

State the differences between sql override and lookup override?

629

Name the different lookup cache(s)?

711

How many input parameters can exist in an unconnected lookup?

1003

Suppose we do not group by on any ports of the aggregator what will be the output?

582

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

569

What are some examples of informatica etl programs?

540

Describe data concatenation?

576

Define the various join types of joiner transformation?

561

What are the new features of informatica 9.x in developer level?

568

How to use pmcmd utility command?

586


Post New Informatica Questions

Un-Answered Questions { Informatica }

What do you mean by filter transformation?

557


What is informatica etl tool?

556


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

635


What is mapplet in informatica?

598


What is a difference between complete, stop and abort?

643






How can we remove the duplicates from flat file source?

583


What is Index Caches size?

625


what is INFORMATICA TESTING process

1844


How does a sorter cache works?

573


Can we override a native sql query within informatica?

632


scenario where i can use only concurrent execution of workflow.

2551


Write the advantages of partitioning a session?

752


How do you update the records with or without using update strategy?

666


What is the maplet?

622


What are batches?

623