top button
Flag Notify
Site Registration

services which form the Informatica PowerCenter processing engine

0 votes
226 views

What are the services which form the Informatica PowerCenter processing engine?

posted Jan 21, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

The following services form the Informatica PowerCenter processing engine:

Integration Service - conducts and implements the ETL logic
Repository Service - manages connectivity to the metadata repositories, where mapping and workflow definitions are saved
Repository Service Process - retrieves, inserts and updates repository metadata. It is a multi-threaded process.
Repository - a database which contains the ETL metadata

answer Jan 22, 2015 by Shweta Singh
Similar Questions
+1 vote

In Informatica's PowerCenter, is it possible to set a parameter's value based on the output of a stored procedure? The parameter I want to set is a parameter I defined in a flat-file data object.

+2 votes

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).

0 votes

I have some files that I would like to consolidate into a single database table. The files have similar but different formats. The files look something like this:

FileOne:
•ColA : string
•ColB : string
•ColC : string

FileTwo:
•ColAA : string
•ColBB : string
•ColCC : string

FileThree:
•Col01 : string
•Col02 : string
•Col03 : string

The destination table looks like this:

TableDestination:
•ColFirst : string
•ColSecond : string
•ColThird : string

I want to develop a mapping that ETLs these three files into this one database, but because the column names are different, it looks like I'll have to develop three different mappings, or three different sources, or three different somethings. The problem is that my example is contrived: I actually have many different files that all have different formats and column names, but the data is all very similar.

I would like to develop a single mapping or workflow that can handle all of this by only adding a table that holds the column mappings. Such a table would look like this based on the sample files and sample table above:

TableMappings:
enter image description here

In this way, to edit a column mapping I only have to make an edit this this TableMappings table. I wouldn't have to make any changes at all to the mapping or workflow. Nor would I have to redeploy an application.

What would a mapping or workflow look like that could take advantage of something like this? I assume there'd be a flat file source that takes files from a folder. There would be something in the middle that uses this TableMappings table to map column names. Finally there would be a relational data object that represents my destination database table "TableDestination". I don't know how to put this together though.

+1 vote

I get this error at the moment of create domain on informatica Powercenter 8.6.1 silent install :

Informatica PowerCenter 8.6.1

Cannot create domain.

The installer could not create the domain. Correct the error below and select
Retry. You must successfully create the domain to continue the installation.
DEFINE_NODE_STDOUT:
DEFINE_NODE_STDERR:java.lang.UnsatisfiedLinkError: pmjrepn (A parameter must be a directory.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:952)
at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:921)
at java.lang.System.loadLibrary(System.java:452)
        at com.informatica.powercenter.sdkint.repository.ILocaleManager.<clinit>(ILocaleManager.java:38)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:187)
        at
com.informatica.pcsf.infacmd.InfaCmdMainLoop.mainLoop(InfaCmdMainLoop.java:100)
at com.informatica.pcsf.infacmd.InfaSetupMain.main(InfaSetupMain.java:34)
Exception in thread "main" java.lang.UnsatisfiedLinkError: pmjrepn (A parameter
must be a directory.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:952)

Any ideas?

...