OWB - SQL Generated (Intermediate Generation Style)

Card Puncher Data Processing


When designing a mapping, you have the possibility to see the SQL generated by OWB with the intermediate generation sql feature. It permits to see the SQL for the complete mapping as for an intermediate SQL by choosing an intermediate group of an operator.

How to

To see the SQL generated:

  • Generate the mapping.
  • In the generation result view, select Intermediate for generation style and choose a group.

If you don't choose a group, you can have this message : “Please select an attribute group”.

Example for a filter:

Owb Intermediate Sql

Discover More
Card Puncher Data Processing
OWB - How to debug a Mapping ?

Oracle Warehouse Builder give several way to find information to debug a mapping : a that enables you to see the data flow through the mapping in a graphical interface. The mapping debugger is embedded...
Key Lookup Inputconnection
OWB - Key lookup operator

Use the Key Lookup operator to lookup (retrieve) data from a set of data (filter,table, view, cube, or dimension ...) For example, use the Key Lookup operator when you define a mapping that loads...

Share this page:
Follow us:
Task Runner