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

Explain lookup transformation is active in informatica

0 Answers   Informatica,

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

why we use datawarehouse

0 Answers   HCL,

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

What is an Integration service in Informatica?

0 Answers  

What is a router transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories