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 4571

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

1 2607

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

GE,

1 2923

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,

1545

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,

2481

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

1468

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 2552

Target increases every day even though no new record was inserted

Accenture,

1627

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

1 2111

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

1522

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,

1680

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

Deloitte,

1 2843

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,

1559

On which transformations you created partitions in your project?

Cap Gemini,

1438

can anyone suggest best free Talend data integration training online

1745

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to do unit testing in informatica?

1229

where to store informatica rejected data?

1141

Global and Local shortcuts. Advantages.

2091

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1100

What are the new features of informatica 9.x in developer level?

1055

what is $$$$?

2204

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8313

What is the Rank index port in Rank transformation?

1105

How can a transformation be made reusable?

1241

What is source qualifier transformation in informatica?

1066

How do you take back up of repository?

1210

How can we use mapping variables in informatica? Where do we use them?

1294

What is a node in Informatica?

1087

What do you mean incremental aggregation?

1131

What is meant by query override?

1118

For More Un-Answered { Informatica } Questions Click Here