Stop Transaction

[kpmINFO]

I would like to know how I can stop processing all the records if I encounter an error condition, I know I can use abort, but abort function stops the session, I do not want this.
here is the illustration of what I would like to do
I have a source with 10 records, using informatica I am validating all the records, If I encounter an error with any of the records I would like to insert this error record into the data base and stop processing other records, can I achive this using Informatica.

 

[blom0344]

Sure you can, but what do you mean with 'error record'?
Furthermore INFA will read the records from the source in no particular order if not forced to, so do you want to just load the error record to a target?

If you use sorted input I would recommend using a sequence generator to index the records. If record 7 is the first 'error record' than load this to the target with a datestamp. You can then use a second mapping to delete any other set (1-6 or 1-6/8-10) from the target in a second run

T. Blom
Information analyst
tbl@shimano-eu.com

 

[kpmINFO]

Maybe i didnt give you enough details , btw im using PC6.2 .

I have Log error records in Error DB table and the valid ones into STG table. as per your answer i gather u wud need to run two sessions , but is it possible to do it in a single session. Because otherwise i need to run two dependent sessions . Also I was thinking about the transaction control transformation but im not sure about how to use it as such, if you had dealt with it can u provide inputs.

Thanks,
PM