Preparing the data to be written into MDM
Procedure
-
Double-click tFixedFlowInput to view its
Basic settings in the Component tab.
- Click the ... button next to Edit schema to open the schema editor.
-
Click the [+] button and add five columns of the
type String.
In this example, name the columns id, account, firstname, lastname, and staging_source.
- Click OK to close this dialog box, and then click Yes in the Propagate dialog box to propagate the schema changes to tMDMOutput.
- Keep the default value 1 in the Number of rows field.
- In the Mode area, select Use Single Table.
-
In the Value fields, enter between quotes the
values which correspond to each of the schema columns.
Column
Value
id
CRM01
account
188
firstname
John
lastname
Doe
staging_source
CRM
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!