How many repositories can we create in Informatica?

Question

When we do not know the number of targets, Can we create the targets at run time using informatica Powercenter.

Suppose we have below source:
Employee:

Dept_ID      EmpName  Sal
10           A        200
11           B        100
10           C        200
10           D        400
12           E        500
12           F        400

...

It can have any number of distinct Dept_ID. I want to load all EmpName and Sal of a particular Dept_ID into a separate target table (i.e target name should be as Tar_10 or Tar_11 where 10 & 11 are Dept_ID).

Answer 1

We can create any no. of repositories in Informatica Under one server i.e. only one global repository. You can install one Repository Server on a Windows machine.