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

Informatica Interview Questions

Questions Answers Views Company eMail

Write the unconnected lookup syntax?

1051

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

1068

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

1133

What is dimensional table? Explain the different dimensions.

1127

What are the types of caches in lookup?

993

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

933

Differentiate between router and filter transformation?

967

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.

1641

What are the differences between oltp and olap?

934

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

908

Differentiate between reusable transformation and mapplet.

1047

Why update strategy and union transformations are active?

1003

What is meant by target load plan?

929

How to join three sources using joiner?

1050

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

1072

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1029

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

8988

What are the different types of olap? Give an example?

994

Explain the aggregator transformation?

1109

What is parallel processing in informatica?

1644

Mention few power centre client applications with their basic purpose?

905

What does role playing dimension mean?

1015

Write the prerequisite tasks to achieve the session partition?

1095

Explain the scenario which compels informatica server to reject files?

1112

Is it possible to create multiple domains on a single Informatica server?

1195

explain about unit testing? in real time?

2157

Do you find any difficulty while working with flat files as source and target?

1063

Reusable transformation and shortcut differences

1799

Can informatica load heterogeneous targets from heterogeneous sources?

1134

What are the different transaction levels available in transaction control transformation?

1141

For More Un-Answered { Informatica } Questions Click Here