my requirement is to delete specific records from a hashed file. The file has been created in a project. The file's layout is as follows:
BUS_KEY
SRC_SYS_ID
CRC
CREATE_EW_DTTM
The first two columns are the key columns.
The first three columns are VARCHAR.
The fourth column is Timestamp.
I read some posts and I decided to go with the UV stage method. I created a job with a UV stage and a User-defined SQL:
Code: Select all
DELETE FROM #HASHED_FILE_NAME# WHERE CRC = 'D';
Sequential_File_77.IDENT1: |SQL statement has incorrect number of result columns.|
I then changed the design of the job, eliminated the Sequential File stage and brought in a Transformer stage. I linked the Transformer stage with an out link ot the UV stage and set up the Transformer as dummy stage.
I ran the job and the job did not abort but it apparently did not execute the SQL since the targeted records are still in the file.
What is it that I am doing wrong?
Thanks