How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---

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,

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---

What is polling?

1 Answers  

---

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

---

Explain the types of lookup transformation?

0 Answers  

---

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,

---

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,

---

What are the types of metadata that stores in repository?

2 Answers  

---

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

what is materialized view?

2 Answers  

---