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

Informatica Interview Questions

Questions Answers Views Company eMail

What is hash partition?

1 8336

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 19305

What is the filename which you need to configure in UNIX while installing infromatica?

Accenture,

2 15074

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 5675

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 48396

why do u use shortcuts in informatica.?

iFlex,

4 29183

how do u move the code from development to production?

6 12945

what is confirmed dimension?

6 14002

Kimball and Inmon methodologies?

2 17118

star and snowflake schema?

6 13731

surrogate keys usage in Oracle and Informatica?

ITC Infotech, Oracle,

5 15955

scd methodology?

2 6288

version controlling in informatica?

3 18043

what r the values tht r passed between informatics server and stored procedure?

1 5476

what is parallel querying and what r hints.

1 5502

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the main issues while working with flat files as source and as targets ?

1227

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2412

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1345

How to improve the performance of a session using sorter transformation?

1191

What are Dimensional table?

1122

Define pmcmd command?

1109

Explain the different kinds of facts.

1026

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1158

Can informatica load heterogeneous targets from heterogeneous sources?

1239

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1149

Describe data concatenation?

1127

What is joiner change?

1194

Explain joiner transformation in informatica

1174

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202

expain about the tune parameters?

2460

For More Un-Answered { Informatica } Questions Click Here