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 2537

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

GE,

1 2850

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,

1496

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,

2420

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

1416

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 2037

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 2766

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,

1510

On which transformations you created partitions in your project?

Cap Gemini,

1347

can anyone suggest best free Talend data integration training online

1690

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1109

How to use pmcmd utility command?

1032

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2065

What is the difference between informatics 7x and 8x and what is latest version?

1085

What are the different ways to implement parallel processing in informatica?

1423

What is a repository manager?

1093

What is union transformation in informatica?

1146

What is meant by active and passive transformation?

1125

What is a filter transformation and why it is an active one?

968

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

Explain why we use partitioning the session in informatica?

1090

What are the different types of repositories created using informatica?

1136

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

8116

Which is the t/r that builts only single cache memory?

1190

What is event and what are the tasks related to it?

1122

For More Un-Answered { Informatica } Questions Click Here