Global and Local shortcuts. Advantages.
Have you worked with/created Parameter file
What's the layout of parameter file (what does a parameter file contain?)?
Why do you use Mapping Parameter and mapping variable?
Slowly changing dimensions, types and where will you use them
What are the modules in Power Center
Parameter and variable differences
Reusable transformation and shortcut differences
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)