Cross-Schema Database Name Field in Postgres SQL

[Tim_Ouimet]

Planning the layout of databases for Postgres SQL.

Right now - using MSSQL - have a DB for STAGE and one for FACT.

Converting to Postgres SQL, having single connection to EDW db in MS SQL can reference multiple schema (dbo, etc).

How do you specify a table in different schema in the tDBOutput component for a Postgres SQL connected db?

[Shicong_Hong]

Hello 

You must specify the schema name in the Schema field. If multiple schemas exist, you can use context variables to dynamically modify the schema name within a single subjob.

Regards

Shicong