Make distinction between data informant and target informant - refer to overview article.
There's amost always a mapping required; whether it's done in a TOOL script, a view or in the model.
Name data informants appropropriately (to indicate their strong data dependence) as opposed to target informats which tend to be more generic. E.g. use “_data” suffix for name, “_d” for index.
I usually tackle moderately complex imports in a stand alone TOOL script (not a view) kept alongside the source data, which produces a whatIf-friendly output (TOOL or text), along with informants.
Some situations in which this occurs:
Write and run script with this format:
Get informants from file Export informants
Inspect informants, and create mappings. Grow script to:
Get informants from file !Export informants (now optional) Define mappings (from parameters or from external file) Create/import data with data informants Apply mappings Export data