How many repositories can be created in informatica

Like this: Like Loading What is the size of your project and what is the size of source file? Take care!! Superb blog! Do you have any hints for aspirinhg writers? Its truly awesome post, I have got much clear idea about from this piece of writing. Can you tell us more about this? Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:.

Email required Address never made public. Name required. Follow Following. How many repositories can we create in Informatica?

What is aggregate awareness? What are parallel queries and query hints. Interview Candidate Mar 2nd, 5 First Prev Next Last. Even if that didn't happen I am sure dispatch queues will be so heavy that you might see moderate to severe delays from the objects to start and finish. Thanks Vaibhav, can you please post your thoughts on " if can we have multiple installations for dedicated services. I think you can still go ahead with installing PC and DQ but when it will come to bring them up your license would be checked.

Theoritically it shouldn't cause issue of running PC and DQ for same repository from different domains since it would be the RS database connection string which would point to the same database so I think it shouldn't matter.

If yes how does this reflect in license which would point to the same database so I think it shouldn't matter. And lastly if the license are running on cores based then aren't we running on cores on two different servers? Is this approach correct? One item I would like to point out with this thread. The number of repositories sitting inside of single domain really is not an issue unless it exceeds the number of repositories you are licensed for totally.

The rep service does not take a lot of processing except in the case of some mass issuing of pmrep commands. If you have bought the appropriate lab licenses the monitoring will report that you have exceeded your license but usually this does not cause a compliance issue.

The area I would be more concerned with is the number of nodes tied to the intgration services inside of this one domain and your total core count dedicated to processing.

Are you cutting yourself short on processing power for the sake of administration? As of my knowledge PowerCenter repositories and DQ repositories are completely different entities. You can spread them wherever you want to.

So it shouldn't matter in which domain and on which node each one runs. Again, assuming that my understanding is correct. Sai, your assumption about running processes on different nodes is correct; if you run processes on two servers, both servers contribute to the overall license "consumption", and this does matter in terms of license cost, no question.

I agree with Shannon that the Repository Services usually don't need much processing power; under normal working conditions they are responsible mostly for coordinating processes accessing the repositories and not much more. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Data Management. Tags: Informatica.

Rajiv Gupta December 12, 0 Comments.