Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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!


Question Posted / phoenixuser


Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1..

Answer / kapil

Aggr transformation returns last row of each block or each
group. So here are the ans
Output of Case 1)
3 New Delhi 8000

Output of Case 2)
1 Chennai 4800

Output of Case 3)
1 Chennai 14300

Is This Answer Correct ?    10 Yes 1 No

Post New Answer

More Informatica Interview Questions

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

What is A cache?

2 Answers  

What is Data Caches size?

0 Answers   Informatica,

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

what is hash table in informatica?

1 Answers   Zensar,

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

Can you generate reports in Informatcia?

1 Answers  

how to create user defined function (udf) in informatica

0 Answers   Informatica,

Parameter and variable differences

0 Answers  

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories