can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
Eliminating of duplicate records without using dynamic lookups
what are the different Reporting and ETL tools available in the market?
State the differences between shortcut and reusable transformation
What are the ETL Testing Operations?
how do u really know that paging to disk is happening while u are using a lookup transform?
how do u automate Extraction process?
how would u estimate the size of Lookup transform data and index cache?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
What are the types of Data Warehouse applications?
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 do use session mapping parameters ?(in which transformation)
what is the difference between OLTP database and data warehousing database?