Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

what is meant by drill through?(Mascot)

what is pmrep command?

what happens if the info.server doesn't find the session parameter in the parameter file?

Can u access a repository created in previous version of Informatica?

DELL,

Eliminating of duplicate records without using dynamic lookups

what are Lookup caches options? Including persistent caches.

Difference between flat files and relational sources?

what is session partitioning?

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

Identifying the bottlenecks in various components of Informatica and resolving them.

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

what is pmrep command?

what happens if the info.server doesn't find the session parameter in the parameter file?

Can u access a repository created in previous version of Informatica?