1 of 1 people found this helpful
Yes, but there's nothing like a "source filter condition where reading starts". You have to build this yourself.
Read the data from the CSV file as usual.
Insert an Expression transformation with a variable port named "v_trigger_value_found" of type Integer and set it to the following term (assuming that the the column in question is indeed named A):
IIF( A = 'xyz', TRUE, v_trigger_value_found)
Next set up an output port "Forward_Data" of type Integer with this expression:
Now forward all data from the source plus this port Forward_Data into a Filter transformation with the following expression:
The Filter will let pass through only records which follow the first record with column A = 'xyz'.
At least that's how I would implement it in PowerCenter. As far as I know, you can use the same principle in mapping tasks which you build yourself in ICS and IICS.
Thanks Nico for the quick response !!