Answer / jaimeen shah

if you talk about in Informatica then in mapping use
Source Definition --> Source Qualifier (Default T/R) -->
Modified the SQ query to load the data that you have
required.
select empid, ename, sum(sal) as totalsal from test1
Group by years, ename, empid
Order by ename, empid
and connect the SQ ports to Target definition.
It gives you the result which you require.

Answer / kumarvijay

If your source is file then use agrregator with aggregation
on year,emp_id have port with sum(sal).

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

where actually the usage of push down optimization happens...

2 Answers  

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

permutations of mapplet

0 Answers   TCS,

---

what is the predefined port in dynamic lookup

2 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,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

---

How to create the source and target database connections in server manager?

0 Answers   Informatica,

---

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

---

Write the advantages of partitioning a session?

0 Answers  

---

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

---

what is workflow varible

1 Answers   HP,

---