PowerCenter Modernization

Back Next

PostgreSQL advanced properties

The following tables lists the PostgreSQL properties that you can configure for a

Connection Map configuration

The following table describes the PostgreSQL connection properties:

Connection property	Description
Schema	The PostgreSQL schema name to be used when creating the object. Th schema name is similar to the schema name specified in the SCHEMAMAP.properties file. Default is schema_changeit .

The following table describes the PostgreSQL source advanced properties:

Property name	Description
Schema Name	Overrides the schema name of the source object. Default is $$pg_schema .

The following table describes the PostgreSQL target advanced properties:

Property name	Description
Schema Name	Overrides the schema name of the target object. Default is $$pg_schema .

The following table describes the PostgreSQL lookup transformation advanced properties:

Property name	Description
Schema Name	Overrides the schema name of the lookup object. Default is $$pg_schema .