OWB - Table

Card Puncher Data Processing

About

The Table operator enables you to source data from and load data into tables stored

Properties

Operator Level

Data Rules Properties

When a data rule is applied to a table, you can choose the action that you want to perform if the rule is not correct :

  • Ignore (The default)

This simply does not act upon the data rule, so it does not influence the generated code or the mapping logic.

  • Move to error

MOVE TO ERROR means that the data rule is enforced when running the mapping and that all data rows that fail the rule (or any of the rules if you have multiple) is moved out of the target table into the error logging table (MAIN_TABLE_ERR). That failing row does no longer exist in the target table and any selects from it will not see this row.

  • Report

REPORT means that the error rows are written into the error table, but are NOT removed from the target table and remain in the regular select flow from the main table.

Multiple rules on the same table are possible and can be individually configured. In the case that 2 rules are violated, the error reason is concatenated for the record indicating multiple violations.

Owb Table Operator Data Rule Properties

Mapping level

By right-clicking on a mapping, choosing configuration and selecting a table operator, you can configure:

Owb Configuration Properties Table Operator

Create a table

Attribute Sets Tab

Attribute sets is used to :

  • determine which columns on a table are candidates for profiling

Owb Table Attribute Sets Tab

  • filter the column in a table mapping operator. Right click on a operator table, select Display Set.

Data Rule Tab

This tab allow you to add a Data Rule when you click on the Apply Rule button. To know more about the implementation of Data Rule which is an important part of Data Quality in OWB, check this article. OWB - How to implement and manage data rule in a mapping for a table ?

Owb Table Data Rule Tab





Discover More
Owb Table Operator Properties
OWB - Error Table Properties

This page describe the Error Table section of properties and you can find it only for the mapping operators where a load can be perform : Table, View , Materialized View, External Table, ...
Owb Table Operator With Err Table
OWB - How to implement and manage data rule in a mapping for a table ?

A data rule in OWB is a property of a table and you can manage its behaviour in the mapping. To implement data rule, you must : in the objects : define a then apply (of add) them to the table...
Owb Load Fact Mdm
OWB - How to load a fact table for a data quality cube ?

In one mapping, you can check all the data rules against a table and you can load the results in one fact table. On the check table STG_VENDOR_SAP4 (in the bottom left side), I have set the data rules...
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...
Card Puncher Data Processing
OWB - Operators

The operators are used in a mapping to create a process and have several types : Source/Target Operators: These operators represent Oracle Database objects in the mapping. It also contains Flat File...
Owb Access Publicview Browser
OWB - Repository Browser

Repository Browser is a J2EE web software interface that permit you to: browse the data dictionary (Public View) execute some basic administrative tasks To be able to connect to the Web repository...
Card Puncher Data Processing
OWB - Target Operator

In a mapping, you can load data in the following operator: Table, View, Materialized View, External Table Dimension Cube flat file
Card Puncher Data Processing
OWB - Target Operator Name Properties

Under the operator name properties of a target mapping operator where you can load data such as: table, View, Materialized View, External Table you can set: Primary Source, Target Load...
Card Puncher Data Processing
Oracle Warehouse Builder

Owb Documentation - Understanding Data Quality Management White...



Share this page:
Follow us:
Task Runner