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 4403

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

1 2451

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

GE,

1 2753

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,

1433

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,

2353

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

1373

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 2400

Target increases every day even though no new record was inserted

Accenture,

1516

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

1 1943

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

1411

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,

1560

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

Deloitte,

1 2644

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,

1445

On which transformations you created partitions in your project?

Cap Gemini,

1253

can anyone suggest best free Talend data integration training online

1623

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the new features of Power Center 5.0?

1702

Explain what are the different types of transformation available in informatica.

1039

What is a dimensional model?

929

What is an expression transformation?

972

What is workflow? What are the components of the workflow manager?

1070

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4071

Why update strategy and union transformations are active? Explain with examples.

1176

What is a predefined event?

1037

Explain what transformation and how many are there in informatica?

891

What is repository manager?

933

How many input parameters can exist in an unconnected lookup?

1493

What is joiner transformation in informatica?

995

What is meant by query override?

1008

What are active transformations.

1597

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1888

For More Un-Answered { Informatica } Questions Click Here