Mapping guidelines - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T20:19:56.898694

There are a couple of key guidelines you must follow in order to obtain the results you expect.

  • Important: All target fields must be mapped

If all the target fields are not mapped, then the target record will not be written. This can be accomplished through explicit source to target mapping or with the INITIALIZE command.

The Parser will inform you of which target fields are not mapped, indicated by a return code of 4 upon completion of the Parser.

  • Datastore fields must be fully qualified if you have:
  • Multiple record types/descriptions in a source datastore with the same field names
  • Multiple target datastores that contains fields with the same names.
  • Qualifying datastore fields is explained in more detail in the following sections.