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 18701

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

3 9198

Without source how to insert record to target?

6 19761

How to jion 2 tables, without using any condition?

Amazon,

11 37647

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

4 11053

In joiner, how to load Master table in Target?

2 7878

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

CTS,

5 14107

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

1 6467

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

3 11999

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

3 9042

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

12 22239

How to get EVEN & ODD numbers separately?

8 26552

How to retrieve last two days updated records?

4 10811

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

15 21635

How to merge First Name & Last Name?

8 19334

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?

1077

What are the modules in Power Center

1675

Explian the Process of deployment groups in informatica

1059

Write the prerequisite tasks to achieve the session partition?

1150

How we can create indexes after completing the load process?

1156

Global and Local shortcuts. Advantages.

2032

Explain what is informatica metadata and where is it stored?

1047

What are the differences between oltp and olap?

969

COM components can be used in Informatica

2385

Could you explain what is enterprise data warehouse?

1137

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1262

What are the settings that you use to configure the joiner transformation?

1051

what is the -ve test case in your project.

2402

What is dimensional table? Explain the different dimensions.

1168

Differentiate between source qualifier and filter transformation?

1572

For More Un-Answered { Informatica } Questions Click Here