Answer Posted / 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.

difference between repository database and repository service?

1085

---

What is the difference between source qualifier transformations source filter to filter transformation?

998

---

What are the prerequisite tasks to achieve the session partition?

1185

---

How to start a workflow using pmcmd command?

1182

---

What is union transformation in informatica?

1103

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2685

---

What are the limitations of joiner transformation?

1053

---

What are batches?

1019

---

How to go to the older version for a mapping?

1031

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

986

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1023

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2099

---

How to generate sequence numbers using expression transformation?

1029

---

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

2190

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1849

---