Use the procedure below to create connections to link the components and finalize the Job script creation.
Procedure
-
Next to the tLibraryLoad Job script definitions, enter the
following script code to define a Main row connection between the
tFileInputDelimited component and the
tUniqRow component.
addConnection { TYPE: "FLOW", NAME: "row1", LINESTYLE: 0, SOURCE: "tFileInputDelimited_1", TARGET: "tUniqRow_1" } -
Enter the following script code to define a row connection between the
tUniqRow component and the first
tJavaRow component, to pass the unique email addresses to
the validation process.
addConnection { TYPE: "UNIQUE", NAME: "row2", LINESTYLE: 0, SOURCE: "tUniqRow_1", TARGET: "tJavaRow_1" } -
Enter the following script code to define a row connection between the
tUniqRow component and the second
tJavaRow component, to pass the duplicate email addresses
to the ouput component.
addConnection { TYPE: "DUPLICATE", NAME: "row3", LINESTYLE: 0, SOURCE: "tUniqRow_1", TARGET: "tJavaRow_2" } -
Enter the following script code to define a trigger connection between the
tLibraryLoad component and the
tFileInputDelimited component.
addConnection { TYPE: "SUBJOB_OK", NAME: "OnSubjobOk", LINESTYLE: 1, METANAME: "tLibraryLoad_1", SOURCE: "tLibraryLoad_1", TARGET: "tFileInputDelimited_1", } -
Enter the following script code to define a Main row connection between the
tAggregateRow component and the
tSortRow component.
addConnection { TYPE: "FLOW", NAME: "row5", LINESTYLE: 0, SOURCE: "tAggregateRow_1", TARGET: "tSortRow_1" }