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 2761

Have you worked with/created Parameter file

1660

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

Cognizant,

2381

Why do you use Mapping Parameter and mapping variable?

1761

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

1 3329

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 3694

Slowly changing dimensions, types and where will you use them

1710

What are the modules in Power Center

1675

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

2 5358

Parameter and variable differences

2056

Reusable transformation and shortcut differences

1838

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

1 2522

Implementation methodology

1708

Do you have knowledge in ralph kimball methodology

1 3515

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

1753

Post New Informatica Questions

Un-Answered Questions { Informatica }

Differentiate between joiner and lookup transformation?

1100

What is a difference between complete, stop and abort?

1078

What can we do to improve the performance of informatica aggregator transformation?

1091

How can we delete duplicate rows from flat files?

1219

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2045

Plz can any one say me how to get the informatica certification materials and dumps

2044

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

968

What is the different lookup cache(s)?

1082

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2117

How can you validate all mappings in the repository simultaneously?

1363

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2317

What is a passive transformation?

1101

What is the maplet?

1112

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

1195

What is enterprise data warehousing?

1045

For More Un-Answered { Informatica } Questions Click Here