we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

What is metadata reporter?

1 Answers   Informatica,

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

How to view and Generate Metadata Reports?

1 Answers  

---

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  

---

In which scenario did you used pushdown optimization?

1 Answers  

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

---

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

---