Its been a long time since I have developed in DS (usually admin only).
I am trying to write the following job:
Teradata1 -> sort1 -> Copy1 -> merge
then
Teradata2 -> sort2 -> Copy2 -> merge
From the merge (same stage) I have two output links, one for good records, one for bad as following:
Merge -> Teradata3
L - -> Teradata4
What I have in the Teradata3 and 4 stages SQL is:
Code: Select all
INSERT INTO #pTDRESDB#.#pTDRESTABLE#
(DBName, TBName, CompareResult, DataDate, RowCount
VALUES ('#pTDSRCDATABASE#','#pTDSRCTABLE#','OK',?,?)
Is there any way I can achieve this (in the one job) without writing a separate load job?Teradata_Connector_81: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
Thanks.