SQL Override

Description

1 INFA Mind Map on SQL Override, created by dbrown on 18/11/2013.
dbrown
Mind Map by dbrown, updated more than 1 year ago
dbrown
Created by dbrown about 11 years ago
37
0

Resource summary

SQL Override
  1. Properties TAB
    1. Sql Query
    2. Do not change the ports or the port order
      1. SQL Query overrides the User-Defined Join, Source Filter, Number of Sorted Ports, and Select Distinct
        1. enclose all database reserved words in quotes
          1. Can override at the session level
            1. Properties TAB on the Sources node
              1. WM does not validate the SQL
            Show full summary Hide full summary

            Similar

            Transformation Functions
            dbrown
            Lookup trans
            dbrown
            Properties of Lookup
            dbrown
            Lookup query
            dbrown
            Lookup condition
            dbrown
            Lookup Ports
            dbrown
            Returning multiple rows
            dbrown
            Lookup Cache
            dbrown
            Database Deadlock Resilience
            dbrown
            HTTP Properties
            dbrown
            Source Qualifier Transformation
            dbrown