1. User Guide
  2. Data Administration
  3. Data File Specification
  4. Data Loaders
  5. Dimension Data Loader
  6. Data Preparation Guidelines

3.2.2.1.4 Data Preparation Guidelines

While creating the data files, ensure the following:

  • Ensure the data files are in TXT, DAT, or CSV formats.
  • Ensure that there are no duplicate records in a data file.
  • Data file names are in the prescribed format.
  • Use only comma (,) and/or pipeline (|) as delimiters.
  • Only double quotes (“”) are used as Field Enclosures.
  • The language code must be as per BCP 47 format. For example, en-US.
  • In the file for hierarchies, there must be no empty space or special characters for HIERARCHY_CODE.