Implementation methodology
According to his methodology what all you need before you build a datawarehouse
Sequence generator, when you move from develoment to production how will you reset
Whats there in global repository
Repository user profiles
How do you set a varible in incremental aggregation
Scheduling properties,whats the default (sequential)
Partition, what happens if the specified key range is shorter and longer
Performance tuning( what you did in performance tuning)
what are factless facts? And in which scenario will you use such kinds of fact tables.
How big was your fact table
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the main features of Oracle 8i with context to datawarehouse?
What are the new features of Power Center 5.0?
Differentiate between Load Manager and DTM?