The Definitive Guide to Data Quality
Solved! Go to Solution.
I do not know whats wrong with your job but normally this design should work.
But because you do not use prepared statements you can simplify your job with the tPostgresqlInput component.
The method you suggested here to use txxxRow and tParseRcord set works great. However, I have a scenario like :
Say input is 100 records to txxxRow and in the select SQL of txxxRow finds a match for Only 90 records. So, it passes only 90 to tParseRecorset.
Question is :
How to collect that 10 UNUSED records ? Can you please sugest some way around.