What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is tracing level?
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.
How etl testing is different from database testing?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is granularity in Data ware House?
what are the concerns of OLTP and DSS systems?
how do u set partition points in the mapping?
Explain etl mapping sheets?
How to delete data which is not in source table?
What are three tier systems in etl?
What is the difference between project backlog and product backlog?
Define slowly changing dimensions (SCD)?
what is the use of structures?how many nodes can u create in a structure?
how would u estimate the size of Aggregator transform data and index cache?
