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 are the reusable transforamtions?

1 Answers  

why u go for dimensions ?

3 Answers   TCS,

How i can upload the MainFrame source For Informatica ?

1 Answers  

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

Explain incremental aggregation in informatica

0 Answers   Informatica,

What is data caches/ index caches?

0 Answers  

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

performance tuning of Informatica

1 Answers  

wf dont have integration severances how you can run?

0 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories