write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

---

Tell me about informatica architecture.

2 Answers   TCS,

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

How can repository reports be accessed without sql or other transformations?

0 Answers  

---

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

---

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,

---

what are presession,postsession success and postsession failure commands ?

1 Answers  

---