Nu am putut găsi această intrare. Se afișează rezultate aproximative. Verificați ortografia sau propuneți adăugarea acestui termen în dicționar.
セット・ベース
セットベース
Setベース
For a mapping that contains a Filter operator, code that displays the filter condition expression as a WHERE clause for set-based view mode is filter input names in the original filter condition are replaced by actual column names from the source table, qualified by the source table alias.
You can use an external table to combine the loading and transformation within a single set-based SQL DML do not have to stage the data temporarily before inserting it into the target table.
Inserts and updates are done in bulk set-based processing to maximize performance. You can also perform data integrity checks by invoking the Control KM.
Inserts and updates are performed by the bulk set-based MERGE statement to maximize performance. It also allows performing data integrity check by invoking the Control KM.
There are two broad families of computer languages: declarative language that describes what should be done, and imperative language that describes how things should be done. You are probably already familiar with the Structured Query Language, or SQL, the database-independent language for defining database objects and is a set-based, high-level declarative computer language; it describes a problem by stating criteria for the desired data. Using SQL statements, you can query tables to display data, create and modify objects, and perform a large variety of administrative tasks. When you issue a SQL command, the SQL language compiler automatically generates a procedure to access the database and perform the desired task.
OWB generates PL/SQL code for all mappings that do not contain either a flat file operator as a source, or a SAP/R3 source. Design considerations for PL/SQL mappings depend upon whether you specify a row-based or set-based operating mode.
Warehouse Builder provides error logging for the tables, views, and materialized views used in set-based PL/SQL mappings. To enable error logging, you set the Shadow table name property of the table, view, or materialized view. DML error logging is supported only for target schemas created on Oracle Database 10g Release 2 or later versions.
Chunking avoids the need for large rollback segments. Set-based SQL statements for large updates require large rollback segments, because a single set-based statement does not perform intermediate commits.
Do not select set-based mode as Warehouse Builder then generates code that creates one statement for all insert transactions, one statement for all update transactions, and a third one for all delete code then calls these procedures one after the other, completing one action completely before following up with the next action. For example, it first handles all inserts, then all updates, and then all deletes.
While many of the operations can also be performed using operations in the WHERE clause or HAVING clause, there are some operations that are very difficult to perform in any way other than using these set-based operators.
こうした操作の多くは WHERE 句や HAVING 句を使用しても実行できますが、中にはこれらの集合ベースの演算子を使用せずに実行するのは非常に困難な操作もあります。
Conținut posibil inadecvat
Exemplele au rolul de a te ajuta să traduci cuvinte sau expresii corect si adaptat la context. Nu sunt selectate sau validate manual, așadar pot conține termeni inadecvați. Te rugăm să raportezi exemplele pe care le consideri inadecvate. Traducerile vulgare sau colocviale sunt în general marcate cu roșu sau cu portocaliu.