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

Informatica Interview Questions

Questions Answers Views Company eMail

Useful UNIX commands regular/frequently used

Deloitte,

1 4493

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 2538

Why the workflow is failed after running two hours in informatica?

GE,

1 2852

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

Cap Gemini,

1498

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

Cap Gemini,

2421

How to load a Dimension ? and how to load a fact table?

1418

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

Wipro,

1 2481

Target increases every day even though no new record was inserted

Accenture,

1580

Which is the best place to learn Informatica Powercenter Online Training?

1 2038

Can we get 1st record through Informatica(without sequence number).

1479

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)

Saama Tech,

1628

Using Connected or unconnected lookup for performance wise which one is preferable?.

Deloitte,

1 2767

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

HCL,

1511

On which transformations you created partitions in your project?

Cap Gemini,

1348

can anyone suggest best free Talend data integration training online

1690

Post New Informatica Questions

Un-Answered Questions { Informatica }

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1322

Which version configuration tool used in ur project?

3258

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6178

How can we remove the duplicates from flat file source?

1040

What is informatica worklet?

1067

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

1167

What is a surrogate key?

1081

What are the different options available for update strategy?

1003

What are the tuning techniques you applied during your last project

2026

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2340

generate date / time dimension in informatica

1125

What are the restrictions of union transformation?

1041

If informatica has its scheduler why using third party scheduler?

1268

How can you generate reports in informatica?

1029

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

2174

For More Un-Answered { Informatica } Questions Click Here