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

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.

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.

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

---

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

---

what is mapping optimization? wat are the techniques for tat

2 Answers  

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  

---

What is critical mapping?

2 Answers  

---

what is the dashbords?

1 Answers   IBM,

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

---

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

21 Answers   Deloitte,

---

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

---

.prm wirh repalce .txt is possible?

2 Answers  

---