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 4495

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

1 2542

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

GE,

1 2855

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,

2424

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

1420

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 2483

Target increases every day even though no new record was inserted

Accenture,

1582

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

1 2039

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 2771

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,

1512

On which transformations you created partitions in your project?

Cap Gemini,

1349

can anyone suggest best free Talend data integration training online

1693

Post New Informatica Questions

Un-Answered Questions { Informatica }

How we can create indexes after completing the loan process?

1211

What is the function of aggregator transformation?

1087

What are mapplets? How is it different from a Reusable Transformation?

1094

What are the different clients of powercenter?

1062

How to generate sequence numbers?

1091

Can you generate sequence numbers without using the sequence generator transformation?

1124

What is pmcmd command?

1125

How will the document be delivered to me?

1085

What is meant by LDAP users?

1211

What are the main issues while working with flat files as source and as targets ?

1165

What are the informatica performance improvement tips

1095

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

1479

How to open an older version of an object in the workspace?

1207

tell me the rules and responsblites in our project(my project is development)

1933

What is the format of informatica objects in a repository?

1021

For More Un-Answered { Informatica } Questions Click Here