Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 1626

Explain the shared cache and re-cache?

1166

What are the features of complex mapping?

1210

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

1018

What is a rank transform?

1148

What is meant by lookup transformation?

1186

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

1034

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?

1151

What is mapping debugger?

1070

Mention a few design and development best practices for informatica?

1047

How can we store previous session logs?

1140

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

1147

How an expression transformation differs from aggregator transformation?

1089

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

1149

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

1189

Post New Informatica Questions

Un-Answered Questions { Informatica }

how we can load rejected record's at run time?(not through bad files)

2433

What is an expression transformation?

1081

Differentiate between Load Manager and DTM?

2216

How to generate or load values in to the target table based on a column value using informatica etl tool.

1118

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1962

Explain the shared cache and re-cache?

1166

Explain constraint based loading in informatica

1157

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.

2052

What is standalone command task?

1376

What are the types of data warehouses?

1579

What are the types of lookup transformation?

1120

Where can we find the throughput option in informatica?

1109

What is difference between a gateway node and worker node?

1204

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

1143

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

1167

For More Un-Answered { Informatica } Questions Click Here