A PowerCenter Repository is a set of tables created when your Informatica Administrator creates a
PowerCenter Repository Service during post installation process. The entire code that a developer
builds is stored inside the repository. Repository contains hundreds of tables, whereas PowerCenter
stores the developer's code within these tables very intelligently. It is hard to manually look at these
tables and comprehend and hence, they should be left alone unless there is a dire need to look at t
them. Along with developer's code, repository also contains metadata like definitions of the tables used
by the mappings, source and target connections, etc… When the developer runs a Workflow (a job in
PowerCenter), its information is fetched from the repository. Thereafter, the runtime statistics are
stored back in the repository again. Hence the repository is a key and live element in PowerCenter
architecture
No comments:
Post a Comment