Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The table below describes the options available for the CSV Input step:

Option 온셥

Description 설명

Step name

Name of the step.

Note: This name has to be unique in a single transformation.

Filename
  or
The filename field (data from previous steps이름

Step의 이름

파일이름
  또는
파일이름 필드 (이전 Step의 데이터)

Specify the name of the CSV file to read from.
  or
Select the fieldname that will contain the filename(s) to read from.
If this step receives data from a previous step, this option is enabled as well as the option to include the filename in the output.

Delimiter 구분자

Specify the file delimiter character used in the target file.

Enclosure 인클로저

Specify the enclosure character used in the target file.

NIO buffer size 버퍼 크기

This is the size of the read buffer.  It represents the amount of bytes that is read in one time from disk.

Lazy conversion

The lazy conversion algorithm will try to avoid unnecessary data type conversions and can result in a significant performance improvements if this is possible.  The typical example that comes to mind is reading from a text file and writing back to a text file.

Header row present 헤더?

Enable this option if the target file contains a header row containing column names.

Add filename to result 결과에 파일이름 추가

Adds the CSV filename(s) read to the result of this transformation.  A unique list is being kept in memory that can be used in the next job entry in a job, for example in another transformation.

The row number field name 로우 번호 필드 (optional)

The name of the Integer field that will contain the row number in the output of this step.

Running in parallel 병렬로 실행?

Check this box if you will have multiple instances of this step running (step copies) and if you want each instance to read a separate part of the CSV file(s). 
When reading multiple files, the total size of all files is taken into consideration to split the workload. In that specific case, make sure that ALL step copies receive all files that need to be read, otherwise, the parallel algorithm will not work correctly (for obvious reasons).

WARNING: For technical reasons, parallel reading of CSV files is only supported on files that don't have fields with line breaks or carriage returns in them.

File Encoding 파일 인코딩

Specify the encoding of the file being read.

Fields Table 필드 테이블

This table contains an ordered list of fields to be read from the target file.

Preview button 미리보기 버튼

Click to preview the data coming from the target file.

Get Fields button 필드 가져오기 버튼

Click to return a list of fields from the target file based on the current settings (i.e. Delimiter, Enclosure, etc.). All fields identified will be added to the Fields Table.