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 18735

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

3 9202

Without source how to insert record to target?

6 19786

How to jion 2 tables, without using any condition?

Amazon,

11 37690

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

4 11065

In joiner, how to load Master table in Target?

2 7886

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

CTS,

5 14127

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

1 6474

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

3 12008

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

3 9053

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

12 22282

How to get EVEN & ODD numbers separately?

8 26581

How to retrieve last two days updated records?

4 10823

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

15 21660

How to merge First Name & Last Name?

8 19356

Post New Informatica Questions

Un-Answered Questions { Informatica }

can u any challenge your project?

2033

what is song in infrmatica...?

2237

what is informatica metadata?

1037

What is the status code in stored procedure transformation?

1182

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628

Differentiate between source qualifier and filter transformation?

1578

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

1116

What are the uses of etl tools?

1128

What is rank transform?

997

What is the need of an ETL tool?

1094

What do think which one is the better joiner or look up?

1203

How to join three sources using joiner?

1115

What is the command used to run a batch?

1063

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128

What is decode in static cache?

1179

For More Un-Answered { Informatica } Questions Click Here