Difference between STOP & ABORT in Informatica.

Answer Posted / umamahesh

The STOP option is used to execute the session task and
allow other task to run, whereas ABORT option completely
turns off the task that is running.

- When using STOP option the integration services stop
reading the data from the source of the file, whereas ABORT
waits for the services to be finished and then only any
actions take place.

- The STOP command processes the data to the source or to
targets, whereas ABORT option has the timeout period of 60
seconds.

- STOP option allows the writing of the data and committing
the data to the targets, whereas ABORT shows no commitment
as such.

- STOP option doesn’t kill any process and it just stops the
resource sharing between the processes, whereas ABORT stops
the process and the session gets terminated.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are ETL Tools?

666


Describe an informatica powercenter?

608


How to extract the informatica rejected data?

753


What are the new features of informatica 9.x in developer level?

559


Explain lookup transformation is active in informatica

662






Can we override a native sql query within informatica?

630


How to load a Dimension ? and how to load a fact table?

955


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1335


Mention few power centre client applications with their basic purpose?

536


What is meant by lookup transformation?

612


Why sorter is an active transformation?

749


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

709


Explain what transformation and how many are there in informatica?

486


How to do the error handling of if ur source is flatfiles?

1512


In informatica workflow manager, how many repositories can be created?

780