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 are the types of maping in Getting Started Wizard?

1 Answers  

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  

---

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

---

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

---

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

---

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,

---

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

---

What are the Differences between static cache and dynamic cache?

1 Answers  

---

Define Update Override?

1 Answers  

---

What are partitions in informatica and which one is used for better performance?

2 Answers  

---

What are the reusable transforamtions?

1 Answers  

---