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 2766

Have you worked with/created Parameter file

1664

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

Cognizant,

2385

Why do you use Mapping Parameter and mapping variable?

1763

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 3697

Slowly changing dimensions, types and where will you use them

1713

What are the modules in Power Center

1680

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

2 5372

Parameter and variable differences

2062

Reusable transformation and shortcut differences

1840

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

1 2528

Implementation methodology

1712

Do you have knowledge in ralph kimball methodology

1 3524

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

1757

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the need for an etl tool?

1068

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

1423

What is sequence generator transformation in informatica?

1078

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1064

what is the Default Source Option For Update Strategy Transformation?

1239

What is status code in informatica?

1020

Write the different tools in the workflow manager?

1065

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1079

Can we get 1st record through Informatica(without sequence number).

1479

Differences between version 7.x and 8.x.

1893

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8223

What is the sql query overwrite in source qualifier in informatica

1090

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7064

server hot-ws270 is connect to Repository B. What does it mean?

2565

For More Un-Answered { Informatica } Questions Click Here