Power center repository
Elucidate briefly power center repository?
Expert
Standalone repository: The repository which functions separately, un-related and un-connected to the other repositories.
Global repository: (Power Center only.) the centralized repository in the domain or the group of connected repositories. Each domain can hold one global repository. The global repository can hold common objects to be shared by the domain throughout global shortcuts.
Local repository: (Power Center only.) A repository in a domain which is not global repository. Each local repository in domain can connect to the global repository and employ objects into its shared folders. Power Center repository is employed to keep informatica's Meta data. Information like mapping location, name, source definitions, target definitions, transformation and flow is kept as Meta data in repository.
Write about the term Data stage architecture?
Explain the following term: a) OLAP b) OLTP
Illustrate the term indexing. Specify the kinds of the indexing.
Illustrate briefly the term SQL sub query?
State the use of data stage jobs?
Illustrates the license for Clipper?
Write down a short note on the difference between partial specialization and total specialization.
Explain the package folders?
Briefly describe the term dimension tables and fact tables?
Write a brief note on a distributed database?
18,76,764
1948997 Asked
3,689
Active Tutors
1435958
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!