Multiple choice technology

A mapping uses a fixed-width flat file source definition, but you learn that the physical file is comma-delimited. The fields are in the correct order. What action, if any, should you take?

  1. No action need be taken provided the new file format is valid.

  2. Edit the source definition properties to make them compatible with the physical file and save the changes to the repository.

  3. Launch the Flat File Wizard using the source definition and edit the properties to make them compatible with the physical file. Save the changes to the repository.

  4. Delete the source definition, save the repository, re-import it using the Flat File Wizard and define the properties to make them compatible with the physical file. Add the new source definition to the affected mappings and save the changes to the reposit
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When the physical file format differs from the source definition, edit the source definition's properties to match the actual file format (delimited vs. fixed-width). This preserves existing mappings while correcting the metadata. No need to delete and recreate the definition.

Keep practicing — related questions