OWB - Flat File

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

Notes about flat file in OWB.

Advertising

3 - Import

To save time during the sample step, you can select Same As <FileName > from the Same As drop-down list. (You must use the Same As option when the file to be sampled is similar in structure to any of the previously sampled files.)

In the field properties step, in the Mask column, you enter it without the without single quotation marks. Example for a date, enter dd-mon-yy

4 - Structure

5 - Definition

  • <CR> : carriage return
  • \n : new line

6 - Data Characteristics Property

String Sizes in: This property indicates how Warehouse Builder handles data with multibyte character sets, such as UTF16. By default, Warehouse Builder assumes the lengths for character strings in the data file are in bytes. You can change the selection to indicate that strings sizes are specified in characters.

Endian: The default for the Endian property is Platform. This indicates that Warehouse Builder assumes the endian of the flat file matches the endian of the platform on which it resides. If the file resides on a Windows platform, the data is handled as little-endian data. If the file resides on Sun Solaris or IBM MVS, the data is handled as big-endian. If you know the endian value for the flat file, you can select big or little-endian. If the file is UTF16 and contains a mark at the beginning of the file indicating the endian, Warehouse Builder uses that endian.

7 - code page / character set

7.1 - How to find the current

To find the current console code page, issue the CHCP command in the Command Prompt window.

437 OEM United State
Advertising

7.2 - NLS_LANG Settings in Console Mode and Batch Mode

Before you can use Oracle utilities such as SQL*Plus, SQL Loader, Import, and Export from the Command Prompt window, you may have to set the character set field of the NLS_LANG parameter to a value different than the one set in Registry.

This is required because programs running in console mode use, with a few exceptions, a different code page (known also as character set) from programs running in GUI mode. The default Oracle home NLS_LANG parameter in the Registry is always set to the appropriate GUI code page. If you do not set the NLS_LANG parameter for the console mode session correctly, incorrect character conversion can corrupt error messages and data.

8 - Documentation / Reference