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 |
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Is snow flake or star schema used? If star schema means why?
Define maping and sessions?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
Write the program through which the records can be updated?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain what is informatica metadata and where is it stored?
How can we integrate different flat file data in a single mapping and with in a single execution
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
What are the out put files that the informatica server creates during the session running?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
Is it possible to revert a global repository to local one and why?