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,

---

In target table how to display the system time

1 Answers  

---

When do you use mapping parameters? (In which transformations)

1 Answers  

---

Can you copy the batches?

3 Answers  

---

why dimenstion tables are denormalized in nature ?

3 Answers  

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

What is repository manager?

0 Answers  

---

how many types transformations supported by sortedinput?

4 Answers  

---

what is mean by grouping of condition column in lookup transformation?

1 Answers  

---

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

---

Explain the etl program with few examples.

0 Answers  

---