Explain about hash partitioning?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
When do we go for the tools in the market?
Eliminating of duplicate records without using dynamic lookups
Explain about round-robi?
how do u decide whether u need to do aggregations at database level or at Informatica level?
how do use session mapping parameters ?(in which transformation)
how many maximum session supports to multiload in teradata ??
Identifying the bottlenecks in various components of Informatica and resolving them.
How we can see table structure?
What exact we can see in table?
What are the types of Data Warehouse applications?
what is dynamic insert?