Page Comparison

...

• Applied to source, not target
• If you want to supply FML for the target, just name the FML so that it will be found by ETLUnit when it is looking for FML for the target.
  • TODO: Fix link when available: SEE FML File Naming Options.

column-list:

• List of source columns to include or exclude when staging data.
• Only the column list that results from the combined filters of column-list and column-list-mode will be chosen from the source file and staged to the target table.
• Q: What if FML is provided to give the source data file columns with different names than those in the target table?
• A: FAIL!  The purpose of FML is to match files.  Without matching field names, ETLUnit cannot match the file layouts.
• Q: What if the count of the net number of columns in the column list (after the include or exclude filter is applied) does not match the number of columns in the source data file?
• A: 
  
  • If column-list is found inside reference-file-type structure, this will fail.
  • If column-list is found outside reference-file-type structure, and it has fewer columns than the source data file, only the enumerated columns will be applied.

...

• Represents a database connection.
• Corresponds to a mode declared in the @Database annotation.
• You cannot use a mode that has not been declared in the @Database annotation.

...

• Used by etl-agent module on behalf of Informatica instance.
• SEE execute operation's list of attributes for Informatica.
• SEE context-name in the execute operation.

Go to top

stage() for List-File Context

...

For example of the stage operation using a data set, see the stage Data Sets page.

data-set-name:

• Required
• Matches the name of a text file in folder 'dataset,' a sibling of the ETLUnit test class.
• The data set text file has file extension '.dataset.'

...