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 materialized view?

2 Answers  

---

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

---

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

---

what is the dashbords?

1 Answers   IBM,

---

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

---

What is a transaction control transformation?

0 Answers   Informatica,

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---