How to use procedural logic inside infromatica?

0 Answers  

---

What is the session task and command task?

0 Answers  

---

What is partioning?how many types of partinings are there

2 Answers   HCL,

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

what is hash table in informatica?

1 Answers   Zensar,

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

What are the Differences between static cache and dynamic cache?

1 Answers  

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

---

What aer the out put files that the informatica server creates during the session running?

4 Answers  

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,

---