How many repositories can we create in Informatica??
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 |
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
How we will implement Pushdown Optimization and Types in Informatica with better examples
Mention few power centre client applications with their basic purpose?
Explain lookup transformation source types in informatica
what are the challenge face in u r project?explain me
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
How mapping parameter and variable works
In real time scenario where can we use mapping parameters and variables?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
What is the surrogate key?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...