in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

How can you increase the performance in joiner transformation?

0 Answers  

---

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

---

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

When will you use SQL override in a lookup transformation?

1 Answers  

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

What are the prerequisite tasks to achieve the session partition?

0 Answers  

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

COM components can be used in Informatica

0 Answers  

---