How can you define user defied event?

0 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  

---

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

---

why we r using presql&postsql in source qualifier?

1 Answers   HP,

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

Insert else update option in which situation we will use

4 Answers   HCL,

---

tell me the push down optimization

2 Answers   Wipro,

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---