How many repositories can we create in Informatica??
- 9 Answers
- 31006 Views
- IBM, Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / murali
We can create any no. of repositories in Informatica Under
one server .As per my knowledge there is no limit .
| Is This Answer Correct ? | 45 Yes | 4 No |
Answer / madhu
We can create any no. of repositories in Informatica Under
one server. You can install one Repository Server on a
Windows machine
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / ram kishore
Any No of Repo v can create only thing is ur db user name n
connect string should be differ.
n u can make them global also
(telling this by personal exp, as I have created 2 repo
both as a globla repo)
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / srinu
We have to crate 60535 repositories in Informatica.
Acctually we have min port no is 5001,max-65535 so each
port no contain one repository in Informatica, any version
of Informatica.each repository will maintain one port no.
This is the correct answer.
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / prats
• Standalone Repository : A repository that functions
individually and this is unrelated to any other
repositories.
• Global Repository : This is a centralized
repository in a domain. This repository can contain shared
objects across the repositories in a domain. The objects
are shared through global shortcuts.
• Local Repository : Local repository is within a
domain and it’s not a global repository. Local repository
can connect to a global repository using global shortcuts
and can use objects in it’s shared folders.
• Versioned Repository : This can either be local or
global repository but it allows version control for the
repository. A versioned repository can store multiple
copies, or versions of an object. This features allows to
efficiently develop, test and deploy metadata in the
production environment.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vickyjam
in that case we have to create 60535 repositories,then what
basis here ur telling that can create 60535 repositories pls
describe it...
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / pallu
Acctually we have min port no is 5001,max-65535 so each
port no contain one repository in Informatica, any version
of Informatica.each repository will maintain one port no.
This is the correct answer.
in that case we have to create 60535 repositories,then what
basis here ur telling that can create 60535 repositories pls
describe it...
In Informatica Power mart we can create any no of
repositories , but we can not share the matadata accross
the repositories,
In Informatica Power center we can create any no of
repositories , but we can disignate only one repository as
a global repository which can access or share matadata
from all other repositories
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nagaraju bhatraju
In Informatica Power mart we can create any no of
repositories , but we can not share the matadata accross
the repositories,
In Informatica Power center we can create any no of
repositories , but we can disignate only one repository as
a global repository which can access or share matadata
from all other repositories
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / bala
In Windows we can create only one Repositor.
We may create more than one in unix\Linux Platforms.
(What i Read i am giving)
| Is This Answer Correct ? | 3 Yes | 39 No |
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Is snow flake or star schema used? If star schema means why?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
What is log file,and where is it located,why u r using the log file
What are ETL Tools?
with out using update strategy transnsformation how to update the data in mapping level
To achieve the session partition what r the necessary tasks u have to do?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
How you know when to use a static cache and dynamic cache in lookup transformation?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
Can yoU use the maping parameters or variables created in one maping into another maping?
Teradata 
