Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between STOP & ABORT in Informatica.
- 3 Answers
- 11683 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 |
What all join we can perform in LOOKUP transformation?
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
Can we get 1st record through Informatica(without sequence number).
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
What are the different options available for update strategy?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
What are the ETL tools available in DWH?
How to differentiate between the active and passive transformations?
What are mapping parametres and variables in informatica?
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
Teradata 
