Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Transform

Description

Parameters

AppendToAttribute

Append a string value to an attribute.

  1. xpath: Path to the attribute in the XML to modify

  2. appendString: String to append to the current value of the attribute

PrependToAttribute

Prepend a string value to an attribute.

  1. xpath: Path to the attribute in the XML to modify

  2. prependString: String to prepend to the current value of the attribute

SearchAndReplace

Perform a regex search/replace on a text node (i.e. attribute or element with text content). If an element with child elements is provided by the xpath, the child elements will all be removed by this operation.

  1. xpath: Path to the text node in the XML to apply search and replace

  2. searchString: Regex search string

  3. replaceString: Regex replace string

InsertElement

Adds an XML element as a child to a specified parent element.

  1. xpath: Path to the parent node. The provided element will be a child of this node

  2. element: XML element to insert (as a string)

InsertAttribute

Adds an attribute to an XML element. If the attribute already exists it will be overwritten.

  1. xpath: Path to the element to add attribute to

  2. attributeName: name of the attribute to add

  3. attributeValue: value of the attribute to add

RemoveElement

Removes an XML element from the document.

  1. xpath: Path to the element to remove.

RemoveAttribute

Removes an attribute from an existing element.

  1. xpath: Path to the element the attribute is in.

  2. attributeName: Name of the attribute to remove.

Recipes

Name

Config File

Description

Change prefetch memory

recipes/change_prefetchmemory.yaml

Change the prefetch memory setting for an ORAOCI9 stage to 102,400,000

Config file: recipes/change_prefetchmemory.yaml

...

Fix ODBC SQL placeholder issue

recipes/fix_odbc_sql_parameter_issue.yaml

This recipe fixes an issue where the following warning is displayed when
migrating an ODBC stage using CCMT:

[WARN] WARNING: The number of placeholders in the UPDATE statement does not match the number of key flow variables so placeholder substitution will not occur.

Info

NOTE:

...

This warning can occur due to a genuine bug in the job in which case this

...

recipe will not fix it. This is a fix for a specific, unusual scenario

...

(described in the yaml file).

...

More recipes coming soon!