On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

---

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

---

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

---

What is data movement mode in Informatica and difference between them?

0 Answers  

---

Differentiate between joiner and lookup transformation?

0 Answers  

---

What is a pre-defined event and user-defined event?

0 Answers  

---

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,

---

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

---

In informatica workflow manager, how many repositories can be created?

0 Answers  

---

can u give example for factless fact table

2 Answers   TCS,

---

What is the need of an ETL tool?

0 Answers   Informatica,

---