Answer / aparna

stop command immediately kills the reading process and does
not have any time period

Abort command gives a time out period of 60sec to the
informatica server to finish the dtm process else it kills

Answer / abhinaw prakash

STOP:When we issue Stop command the integration service
stops reading data from the source though it keeps on
processing and committing the data to the target.

ABORT: When we issue Abort command the integration service
has a timeout period of 60 sec.If its not able to finish
processing and committing the data to the target it kills
the DTM session.

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

How to call shell scripts from informatica?

0 Answers  

---

What are the restrictions of union transformation?

0 Answers  

---

what are the types of Data warehousing ?

1 Answers  

---

can you use flat file for repository?why?

2 Answers   TCS,

---

what are the types of facts with Examples?

3 Answers  

---

What is the difference between view and materialised view?

6 Answers  

---

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,

---

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

---

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

---