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 19785

How to jion 2 tables, without using any condition?

Amazon,

11 37687

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

4 11063

In joiner, how to load Master table in Target?

2 7886

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

CTS,

5 14124

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 9052

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

12 22279

How to get EVEN & ODD numbers separately?

8 26576

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 21658

How to merge First Name & Last Name?

8 19354

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the use of aggregator cache file?

1254

what is diff b/t sorter t/r and agg have the option sorter property...

2171

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2454

What is mapplet in informatica?

1057

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675

Which transformation should we use to normalise the COBOL and relational sources?

1208

What does reusable transformation mean?

1132

How we can use union transformation?

1051

What is enterprise data warehousing?

1047

What is exclusive and normal mode for repository services?

1144

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3870

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2168

What do mean by local and global repository?

1226

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1900

What are the differences between oltp and olap?

972

For More Un-Answered { Informatica } Questions Click Here