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,

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

---

Write the prerequisite tasks to achieve the session partition?

0 Answers  

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

can u give example for factless fact table

2 Answers   TCS,

---

How is union transformation utilized?

0 Answers  

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

---

Why is meant by direct and indirect loading options in sessions?

4 Answers  

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

---

How to create Target definition for flat files?

0 Answers   Informatica,

---