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,

---

Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  

---

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---

What does role playing dimension mean?

0 Answers  

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

---

What are parallel querys and query hints?

1 Answers  

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

Describe expression transformation?

0 Answers  

---

can u give example for factless fact table

2 Answers   TCS,

---

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---