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

Informatica Interview Questions

Questions Answers Views Company eMail

how will you remove the duplicate records from flat file without using sorter?

7 18975

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 9342

Without source how to insert record to target?

6 20013

How to jion 2 tables, without using any condition?

Amazon,

11 38079

How to compare Source and Target table, without using dynamic lookup?

4 11240

In joiner, how to load Master table in Target?

2 7968

Without using Lookup & Sequence Generator, How to generate Sequence?

CTS,

5 14292

Is it possible to have "5 source & 5 Target" in single mapping?

1 6549

How to update records in Target, without using Update Strategy?

3 12146

How to display null values on a target & non-null values on a target?

3 9174

How to extract original records at one target & Duplicate records at one target?

12 22704

How to get EVEN & ODD numbers separately?

8 26845

How to retrieve last two days updated records?

4 10981

In a table, 4 person having same salary. How to get Third person record only?

15 22119

How to merge First Name & Last Name?

8 19606

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to configure mapping in informatica?

1226

How to generate sequence numbers using expression transformation?

1152

What is difference between a gateway node and worker node?

1206

What is an aggregator transformation?

1150

What is workflow? What are the components of the workflow manager?

1175

What is dynamic cache?

1087

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

1168

Reusable transformation and shortcut differences

1884

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

1149

What are multi-group transformations?

1165

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1341

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2074

What is a dimensional model?

1035

What are the advantages of informatica?

1061

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

1119

For More Un-Answered { Informatica } Questions Click Here