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/

Explain the features of connected and unconnected lookup.

0 Answers  

---

Can you copy the session to a different folder or repository?

2 Answers  

---

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

---

Enlist the various types of transformations.

0 Answers  

---

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

---

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

---

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

2 Answers   TCS,

---

How to delete the data in the target table after loaded.

3 Answers   TCS,

---

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

---

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

0 Answers  

---

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

---