Informatica Interview Questions
Questions Answers Views Company eMail

Write the unconnected lookup syntax?

583

Write the unconnected lookup syntax and how to return more than one column.

502

How do you remove duplicate records in informatica? And how many ways are there to do it?

611

What is dimensional table? Explain the different dimensions.

558

What are the types of caches in lookup?

501

What are the types of caches in lookup? Explain them.

483

Differentiate between router and filter transformation?

543

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

920

What are the differences between oltp and olap?

491

What are the types of schemas we have in data warehouse and what are the difference between them?

471

Differentiate between reusable transformation and mapplet.

487

Why update strategy and union transformations are active?

522

What is meant by target load plan?

491

How to join three sources using joiner?

492

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

573


Post New Informatica Questions

Un-Answered Questions { Informatica }

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

485


Is there any target staging area in informatica not staging area

2038


How to update a particular record in target with out running whole workflow?

1064


what are 3 tech challenges/ common issues you face?

1819


How union transformation is used?

521






Briefly define reusable transformation?

564


Explain the informatica workflow?

517


Explain what transformation and how many are there in informatica?

429


How do you take back up of repository?

655


What could be the possible resons of locks by user?

599


What is a predefined event?

582


Which version configuration tool used in ur project?

2661


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.

1560


What is decode in static cache?

515


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

1328