Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

---

How many dimensions are there in informatica?

0 Answers  

---

In target table how to display the system time

1 Answers  

---

.prm wirh repalce .txt is possible?

2 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  

---

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

---

How an expression transformation differs from aggregator transformation?

0 Answers  

---

What are the prerequisite tasks to achieve the session partition?

0 Answers  

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

---

What is Session and Batches?

0 Answers   Informatica,

---

Separate from an archive server and a powerhouse?

0 Answers  

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---