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 a test load?

1 Answers  

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

Can you copy the batches?

3 Answers  

How we can confirm all mappings in the repository simultaneously?

1 Answers  

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

what type of transformation is not supported by mapplets?

4 Answers   CTS,

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,

can we generate reports in informatica ? How?

3 Answers  

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

For more Informatica Interview Questions Click Here
Categories