What is the format of informatica objects in a repository?
Enlist the differences between database and data warehouse.
What is decode in static cache?
What is a pre-defined event and user-defined event?
Enlist the various types of transformations.
What are the different components of powercenter?
Enlist the tasks for which source qualifier transformation is used.
Explain the features of connected and unconnected lookup.
What is informatica? Why do we need it?
What is incremental aggregation?
What is joiner transformation in informatica?
What are the different clients of powercenter?
During the running session, output files are created by informatica server. Enlist few of them.
Explain the aggregator transformation?
Explain the use of aggregator cache file?