Answer / sachin

use an aggregrator where you need to check the group by
port as emp id, ename and year.

Answer / xyz

select empid, year, sum(sal) as Totalsalary
From employees
group by empid, year;

Answer / vikneswaran

use agg trans group by empid and year then use sum(sal)

Answer / ankit kansal

Using SQL->

select empid,ename,year,sum(sal) Total_Sal from table_name
group by empid,ename,year;

Using Informatica->

SRC->SQ->Agg(sum(sal)[group by empid,ename,year])->TGT

http://deepinopensource.blogspot.in/

Reusable transformation and shortcut differences

0 Answers  

---

What all join we can perform in LOOKUP transformation?

0 Answers  

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

Clarify the aggregator change?

0 Answers  

---

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

---

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

---

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

2 Answers   Cap Gemini,

---

Issue with Update override at Target table in Informatica.

2 Answers  

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,

---

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

---