how do u implement configuration management in Informatica?
how many steps are there in etl process?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
What is virtual Data Warehousing?
What is the difference between Data Warehousing and Data Mining?
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 fact? What are the types of facts?
What is meant by incremental load?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what is different between sequential batch and concurrent batch and which is recommended and why?
How can we use external procedural logic in informatica?
what is granularity in Data ware House?
what are the production issues in datastage?
When do we analyze the tables?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)