Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
The Expression transformation has an input/output port for each source column. The transformation returns a connection object name in the Connection port based on the results of an expression.
The following figure shows the Ports tab in the Expression transformation and the input/output port columns for each source column:
The expression returns a connection object name based on whether the location is US, UK, or CAN. When the location does not match a location in the expression, the connection object name defaults to “DBORA_US.”
For example, the following source row customer information for a customer from the United States:
1,John Smith,6502345677,jsmith@catgary.com,US
When the customer location is “US”, the Expression transformation returns the “DBORA_US” connection object name. The Expression transformation passes “DBORA_US” to the SQL transformation LogicalConnectionObject port.