Eliminating of duplicate records without using dynamic lookups

IBM,

what are Lookup caches options? Including persistent caches.

Difference between flat files and relational sources?

Satyam,

what is session partitioning?

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

CTS,

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.

how would u estimate the size of Aggregator transform data and index cache?

how do u decide whether u need to do aggregations at database level or at Informatica level?

QualTech,

how would u estimate the size of Lookup transform data and index cache?

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

how do u really know that paging to disk is happening while u are using a lookup transform?

how do u set partition points in the mapping?

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?