Informatica Interview Questions
Questions Answers Views Company eMail

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 854

Explain the shared cache and re-cache?

602

What are the features of complex mapping?

632

What is a filter transformation and why it is an active one?

553

What is a rank transform?

664

What is meant by lookup transformation?

601

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

524

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?

647

What is mapping debugger?

563

Mention a few design and development best practices for informatica?

549

How can we store previous session logs?

556

What can we do to improve the performance of informatica aggregator transformation?

608

How an expression transformation differs from aggregator transformation?

616

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

623

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

626


Post New Informatica Questions

Un-Answered Questions { Informatica }

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1677


What is main use of mapplet?

646


Sequence generator, when you move from develoment to production how will you reset

1394


What is the use of source qualifier?

659


What are mapplets?

806






What is a grid in Informatica?

602


Describe expression transformation?

625


what are the deliverables?in your project?

1642


What is the advantage of informatica?

637


What are some examples of informatica etl programs?

523


Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2313


What are the tasks that source qualifier perform?

623


what is unit testing?tell me proceedure

1765


What are the measure objects?

647


What is the meaning of up gradation of repository?

1379