Interested to Buy Any Domain ? << Click Here >> for more details...
How many repositories can we create in Informatica??
- 9 Answers
- 33557 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 |
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
Explain Dataware house architecture .how data flow from intial to end?
why u go for dimensions ?
What are Rapid changing dimensions?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
what is incremental data aggregation?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
How to extract sap data using informatica? What is abap? What are idocs?
What is the procedure to load the fact table.Give in detail?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Teradata 
