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

Informatica Interview Questions

Questions Answers Views Company eMail

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 2866

Have you worked with/created Parameter file

1716

What's the layout of parameter file (what does a parameter file contain?)?

Cognizant,

2439

Why do you use Mapping Parameter and mapping variable?

1811

Where do you create/define mapping parameter and mapping variable?

1 3411

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

IBM,

1 3810

Slowly changing dimensions, types and where will you use them

1774

What are the modules in Power Center

1726

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 5468

Parameter and variable differences

2110

Reusable transformation and shortcut differences

1884

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 2620

Implementation methodology

1776

Do you have knowledge in ralph kimball methodology

1 3636

According to his methodology what all you need before you build a datawarehouse

1806

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the components of Informatica? And what is the purpose of each?

1113

What is meant by a domain?

1189

Why do you use Mapping Parameter and mapping variable?

1811

Explain lookup transformation is active in informatica

1152

What do you understand by SOA of Informatica?

1048

Design time, run time. If you don't create parameter what will happen

1895

Explain transaction control transformation in informatica

1312

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8265

How are the sources and targets definitions imported in informatica designer?

1174

How to update or delete the rows in a target, which do not have key fields?

1227

What is the sequence generator transformation in informatica?

1268

What do you mean by enterprise data warehousing?

1109

What do you mean by blocking transformation?

1122

where to store informatica rejected data?

1141

What is workflow manager?

1106

For More Un-Answered { Informatica } Questions Click Here