Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

wht is cdc?how to use it in creation of mappings?

HSBC,

6 22913

wht target override?wht advantages it has compare to target update?

Polaris,

2 13805

how to calculate the optimum cache size in aggregator transformation?

1 7848

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

Alcatel-Lucent, ECI Telecom,

3 9110

What is the difference between Bitmap and Btree index?

Mind Tree,

3 20009

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 9626

How to delete duplicate record in Informatica?

7 30381

What is the difference between view and materialised view?

6 14447

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 6976

how many types transformations supported by sortedinput?

4 8392

what is lookupoverriding?

1 5874

what is the process of target load planing?

IBM,

2 6642

what is the process we used in joiner transformation,there is no matching column in sources?

2 6866

what is the diff b/w union and joiner and lookup?

4 14622

how can u load the data in time dimension?

3 12312

Post New Informatica Questions

Un-Answered Questions { Informatica }

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2744

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

What are the different types of transformation available in informatica.

1105

How can repository reports be accessed without sql or other transformations?

1218

Explain pushdown optimization $pushdownconfig parameter - informatica

1137

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3870

How to extract sap data using informatica? What is abap? What are idocs?

1181

How do you change a non-reusable transformation to reusable transformation?

999

How can you validate all mappings in the repository simultaneously?

1370

What are data-driven sessions?

1205

Reusable transformation and shortcut differences

1840

How would you join a node to the already existing domain?

1129

How to load last n records of file into target table - informatica

1081

What is substr in informatica?

1208

What is the difference between router and filter?

1268

For More Un-Answered { Informatica } Questions Click Here