Difference between STOP & ABORT in Informatica.
- 3 Answers
- 10233 Views
- Accenture, Wells Fargo, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pavani
STOP command instructs Integration Service to STOP reading
input but still continues with processing and commiting.
wherein ABORT has 60 seconds timeout period after which it
kills the process
| Is This Answer Correct ? | 20 Yes | 0 No |
Answer / ratnesh
Stop:will stop reading data from source , continue to process of write and commit
Abort : same as stop , additional has 60 second time period.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain grouped cross tab?
What are the diffrences between joiner transformation and source qualifier transformation?
What is flashback table ? Advance thanks
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
Enlist the differences between database and data warehouse.
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
what is polling?
What is pmcmd command?
EXL informatica Questions
how to connect two or more table with single source qualifier?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Teradata 
