what is a tracing level?

Amount of information sent to log file.

-- What are the types of tracing levels?

Normal,Terse,verbose data,verbose intitialization.

--Expalin sequence generator transformation?

-- can you connect multiple ports from one group to multiple transformations?

   Yes

When you use for dynamic cache.

Your target table is also look up table then you go for dynamic cache .In dynamic cache multiple matches return an error.use only = operator.

Explain Snowflake schema?

Snow flake schema is a normalize dimensions to eliminate the redundancy.The dimension data has been grouped into one large table. Both dimension and fact tables normalized.

Explain Star Schema?

Star Schema consists of one or more fact table and one or more dimension tables that are  related to foreign keys.   

   Dimension tables are De-normalized, Fact table-normalized

     Advantages: Less database space &  Simplify queries.

Explain Surrogate Key?

 Surrogate Key is a series of sequential numbers assigned to be a primary key for the table.

What is a staging area?

Staging area is a temporary storage area used for transaction, integrated and rather than transaction processing.

      When ever your data put in data warehouse you need to clean and process your data.

Difference between Power Center and Power Mart?

PowerMart was reduced functionality and reduced price versus PowerCenter. Since the introduction of PowerCenter 7 PowerMart is no longer sold. Instead PowerCenter is sold as a base product with extra funtionality such as partitioning, team-based development, etc. sold as options.

                                                                    OR

Power center receive all product functionality including ability to multiple register servers and metadata across the repository and partition data.

One repository multiple informatica servers. Power mart received all features except multiple register servers and partition data.