What is the difference between round-robin partitioning and hash partitioning?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what are the types in error loging?
What is the difference between Data Warehousing and Data Mining?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what are the facilities provided by data warehouse to analytical users?
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 is meant by incremental load?
What is etl process? How many steps etl contains?
what is granularity in Data ware House?
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?
What is partitioning? Explain different types of partitioning?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
what is the difference steps for data modeling?
Define Dynamic push down optmization?