What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

I am having a FLAT FILE 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 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

Explain the aggregator transformation?

0 Answers  

---

How can we eliminate duplicate rows from flatfile,explain?

3 Answers  

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

---

What are the types of data warehouses?

0 Answers   Informatica,

---

What is meta data and system catalog?

2 Answers  

---

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---

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,

---

How can we update a record in the target table without using update strategy?

0 Answers  

---

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

---