How many repositories can we create in Informatica??
- 9 Answers
- 30419 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 |
how to get max value record into one target and remaining records into another target?
Where is metadata stored?
Can we combine a flatfile and a database table using an UNION transformation?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
How to generate sequence numbers using expression transformation?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
What is meant by lookup transformation?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
why we use datawarehouse
how to call lookup qualifer in unconnected look;up
Teradata 
