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 4489

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

1 2532

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

GE,

1 2844

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,

1487

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,

2415

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

1408

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 2476

Target increases every day even though no new record was inserted

Accenture,

1569

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

1 2033

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

1475

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,

1624

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

Deloitte,

1 2759

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,

1506

On which transformations you created partitions in your project?

Cap Gemini,

1341

can anyone suggest best free Talend data integration training online

1690

Post New Informatica Questions

Un-Answered Questions { Informatica }

How do you set a varible in incremental aggregation

1883

What is the difference between STOP and ABORT options in Workflow Monitor?

1254

What are connected or unconnected transformations?

1117

Can you use flat files in Mapplets.

2648

Is it possible to use a client with different version than that of its Informatica server?

1134

What is informatica etl tool?

996

Design time, run time. If you don't create parameter what will happen

1833

can u give example for factless fact table

6634

Mention a few design and development best practices for informatica?

994

What is a dimensional model?

977

can anyone suggest best free Talend data integration training online

1690

What are the advantages of informatica?

1007

Explain in detail about scd type 1 through mapping.

1547

Explain the difference between a data warehouse and a data mart?

1056

Differentiate between a repository server and a powerhouse?

1116

For More Un-Answered { Informatica } Questions Click Here