Informatica Common components source qualifier before and after the session SQL

Source: Internet
Author: User

You can add pre-and post-session SQL commands to the Properties tab of the Source qualifier transformation. You may want to use pre-session SQL to write the time identification row to the source table at the beginning of the session.

PowerCenter runs the pre-session SQL command against the source database before reading the source, after the session SQL command is run against the source database after the target is written.

You can override SQL commands in the Transformations view on the Mappings tab of the session properties. You can also configure PowerCenter to stop or continue before the session is run or after the session when the SQL command encounters an error.

Follow These guidelines when you enter a session before and after the SQL command in the Source qualifier transformation.

    • You can use any command that is valid for the database type. However, PowerCenter Server does not support nested comments, even if the database allows it.
    • Mapping parameters and variables can be used in pre-and post-session SQL commands.
    • Use a semicolon (;) Separate multiple statements.
    • PowerCenter Use the/* ... */comment.
    • If you need to use semicolons outside of quotation marks or notes, you can avoid this by using a backslash (\). If the semicolon is escaped, PowerCenter ignores the backslash and does not use a semicolon as the statement delimiter.
    • The Designer does not validate SQL.

Note: You can also enter pre-and post-session SQL commands on the Properties tab of the target instance in the map.

Informatica Common component source qualifier before and after the session SQL

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.