Relational SQL Load

image_pdfimage_print

This load component can call arbitrary SQL statements to a relational database system to modify, update, or delete data. The SQL statement is entered in a free SQL editor. It can be used for CREATE, INSERT, UPDATE, DELETE, or DROP statements.

A connection to a relational database is required. In contrast to the relational load, it has no source assignment, so it is not related to any extracts or transforms.

Stored procedures

The load can be used to call any stored procedures in the relational database system. This offers a convenient way to centralize multiple or complex statements and call them easily.

Example:

Source:

   

Existing relational Table:

Customer:
 A
 B
 B
 C

Value:
 10
 20
 30
 40

 

Customer:
 C

Value:
 5

Results:

Mode ADD, Aggregation=true
 (Customer: Key, Update Mode: sum)

   


Mode ADD, Aggregation=false

 

Customer:
 A
 B
 C

Value:
 10
 50
 45

 

Customer:
 A
 B
 B
 C
 C

Value:
 10
 20
 30
 40
 5


Mode ADD, Aggregation=true
 (Customer: Key, Update Mode: last)

   

 


Mode UPDATE, Aggregation=false

 

Customer:
 A
 B
 C

Value:
 10
 30
 40

 

Customer:
 A
 B
 B
 C

Value:
 10
 20
 30
 40


Mode UPDATE, Aggregation=true
 (Customer: Key, Update Mode: sum)

   

Customer:
 A
 B
 C

Value:
 10
 50
 40

 
               
image_pdfimage_print
Was this post helpful?
NoYes (-1 rating, 3 votes)
Loading...