ETL SQL and Database Operations
9 resources created by 3 users
Top ETL SQL and Database Operations resources
-
27 nodesTransaction Control Transformation active · connected · lets you control comm... · A transaction is the ... · within a mapping: tra... · If you have a flat fi...
-
33 nodesStored Procedure Trans Passive · Connected · to populate and maint... · 3 types of data that ... · Unconnected · When is it run
-
9 nodesSQL Override Properties TAB · Do not change the por... · SQL Query overrides t... · enclose all database ... · Can override at the s...
-
1 questionsUntitled
-
28 nodesUPDATE STRATEGY Transformation ACTIVE · Setting Update Strategy · controls how rows are... · Aggregator before Upd... · Lookup and Update Str...
-
10 nodesSTORED PROCEDURE Transformation used to maintain and ... · 3 types of data that ... · PASSIVE · Connected or Unconnected
Quizzes
Mind maps
-
27 nodesTransaction Control Transformation active · connected · lets you control comm... · A transaction is the ... · within a mapping: tra... · If you have a flat fi...
-
33 nodesStored Procedure Trans Passive · Connected · to populate and maint... · 3 types of data that ... · Unconnected · When is it run
-
9 nodesSQL Override Properties TAB · Do not change the por... · SQL Query overrides t... · enclose all database ... · Can override at the s...
-
28 nodesUPDATE STRATEGY Transformation ACTIVE · Setting Update Strategy · controls how rows are... · Aggregator before Upd... · Lookup and Update Str...
-
10 nodesSTORED PROCEDURE Transformation used to maintain and ... · 3 types of data that ... · PASSIVE · Connected or Unconnected
Notes
-
Transaction Control Transformation - created from Mind Map active connected lets you control commit and roll back transactions based on a set of rows that pass through
-
Stored Procedure Trans - created from Mind Map Passive Connected to populate and maintain databases
-
SQL Override - created from Mind Map Properties TABSql Query Do not change the ports or the port order SQL Query overrides the User-Defined Join, Source Filter, Number of Sorted Ports, and Select Distinct