Which type of Data Source File should be built to accommodate importing data from a delimited file?

Which type of Data Source File should be built to accommodate importing data from a delimited file?

• A. Delimited File
• B. Fixed File
• C. Connector
• D. Data Management Export Sequence

Answer: (A)

Delimited files separate each field with a delimiter, such as a comma or tab. To import this kind of file, you use a Delimited File data source because it’s specifically configured to read the delimiter, recognize whether there’s a header row, handle text qualifiers, and map each column to the target dimensions or data fields. This setup ensures each line is parsed accurately and the data loads into the right places. A Fixed File data source is meant for fixed-width formats where every field starts and ends at fixed character positions, which isn’t appropriate for delimited data. A Connector is used for connecting to external systems or services rather than importing a flat file. A Data Management Export Sequence is for exporting data, not for importing. Therefore, the Delimited File option is the correct choice for importing a delimited file.

Delimited files separate each field with a delimiter, such as a comma or tab. To import this kind of file, you use a Delimited File data source because it’s specifically configured to read the delimiter, recognize whether there’s a header row, handle text qualifiers, and map each column to the target dimensions or data fields. This setup ensures each line is parsed accurately and the data loads into the right places.

A Fixed File data source is meant for fixed-width formats where every field starts and ends at fixed character positions, which isn’t appropriate for delimited data. A Connector is used for connecting to external systems or services rather than importing a flat file. A Data Management Export Sequence is for exporting data, not for importing. Therefore, the Delimited File option is the correct choice for importing a delimited file.