1 | What is passive transformation ? |
2 | What is the difference between connected and unconnected lookups and which perform better ? |
3 | What is Dynamic Lookup? When should this be used? |
4 | How can you improve the performance of aggregator and Rank transformation? |
5 | Joiner transformation is used to join |
6 | Is there any provision for creating flat file target in designer? |
7 | If you have multiples sources from different databases, how and where will you handle the need to specify different DB connection for all of them? |
8 | Can PowerCenter 5.1 handle multiple targets (Targets from different databases)? |
9 | What is Target Load Plan? What is the main constraint for using this? |
10 | Which one of these are the valid tracing levels ? |
