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.
Informatica uses cookies to enhance your user experience, improve the quality of our website, and deliver advertising and other content tailored to your interests. Some jurisdictions’ privacy laws offer their residents specific privacy rights, which we respect as described in our privacy policy. To exercise rights that you may have related to cookies, including opt-out of sharing information with third parties for advertising purposes, select "More Info" or see this "Do Not Sell or Share My Personal Information" link.