Answer / suraj kedia

Aggregator transformation is used to calculate values in a
group. It is the only t/r which can be used for aggregate
calculations e.g: Sum,avg,max,min,count....

So when we don't need any such aggregate calculations, than
we don't use aggregator transformation.

Answer / vikram

when thre are no group by or any other calculations required

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

What is main use of mapplet?

0 Answers  

---

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,

---

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

---

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

---

what is inline view?

1 Answers   IBM,

---

what is SDLC way of code development?

0 Answers  

---

How do you remove duplicate records in informatica?

1 Answers  

---

Why we use partitioning the session in informatica?

2 Answers  

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---