We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
フラット・ファイルからデータ
データをフラット・ファイルから
To extract data from a flat file, use a Flat File operator as a source in a mapping.
For example, a common activity is extracting data from a flat file and loading that data into a table in Oracle accomplish this activity, users might take the following steps, in which they navigate a variety of user interfaces in Warehouse Builder
When designing and implementing a mapping that extracts data from a flat file using SQL*Loader, you can configure different properties affecting the generated SQL*Loader script. Each load operator in a mapping has an operator property called Loading Types. The value contained by this property affects how the SQL*Loader INTO TABLE clause for that load operator is generated. Although SQL*Loader can append, insert, replace, or truncate data, it cannot update any data during its processing.
SQL*Loaderを使用してフラット・ファイルからデータを抽出するマッピングの設計および実装では、生成されたSQL*Loaderスクリプトに影響を及ぼす様々なプロパティを構成できます。マッピングの各ロード演算子には、ロード・タイプと呼ばれる演算子のプロパティがあります。このプロパティに含まれる値は、ロード演算子に対するSQL*Loader INTO TABLE句の生成方法に影響します。SQL*Loaderではデータの追加、挿入、置換または切捨てが可能ですが、この処理中はデータを更新できません。
Use SQL*Loader to load data from a flat file if
次のような場合、フラット・ファイルからデータをロードするためにSQL*Loaderを使用します。
To speed up processing, the application loads data from a flat file into memory.
You can introduce source data from a flat file into a mapping either through an external table or a flat file the following guidelines to decide between the two
You can introduce source data from a flat file into a mapping either through an external table or a flat file decide between the two options, consider how the data must be transformed.
After you have created the file module and imported the flat-file metadata, you are ready to import introduce data from a flat file into an OWB mapping either through an external table or a flat file operator. Depending on how the data is to be transformed, use one of the following options
For example, you create a knowledge module to extract data from a flat file and load it into an Oracle tasks comprising this knowledge module contain ODI substitution methods. When you associate this knowledge module with an execution unit containing data objects in a mapping, Warehouse Builder generates code that extracts data from the specified source object and loads the data into the specified target object.
In Warehouse Builder, use the external table object and the Mapping External Table operator to load data from a flat file into the workspace. The design benefit of using external tables is that it extends additional database features to a using external tables instead of flat files, you can apply complex transformations to the data in flat files that were previously only used for relational files.
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.