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

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL
USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT
WILL TAKE ONLY THE LAST COLUMN WHY????

Question Posted / anirvin2009

Answers were Sorted based on User's Feedback



IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SEL..

Answer / prathap

IF GROUPBY IS NOT SELECTED INFORMATICA SERVER UNDERSTANDS WHOLE TABLE AS A ONE GROUP AND ITS GIVE LAST RECORD OUT

Is This Answer Correct ?    2 Yes 1 No

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SEL..

Answer / amedela chandra sekhar

Aggregator t/r perform calculations from first record to
last record.There is no group it will take last record
if u are not selected groupby the integration service returns
last record from all input rows.

Is This Answer Correct ?    4 Yes 5 No

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SEL..

Answer / amedela chandra sekhar

when u want to perform calculations on groups u can go for
aggregator t/r.aggregate functions like
min,max,last,first,count ...

if u are not selected groupby the integration service returns
last record from all input rows.

why means that integration service rule.

Is This Answer Correct ?    3 Yes 7 No

Post New Answer

More Informatica Interview Questions

What are the tuning techniques you applied during your last project

0 Answers  

What is Cognos script editor?

0 Answers   Cognizant,

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

what is inline view?

1 Answers   IBM,

What are the transformations that are not supported in mapplet?

0 Answers  

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

What is power center repository?

1 Answers  

Define the various join types of joiner transformation?

0 Answers  

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

why dimenstion tables are denormalized in nature ?

3 Answers  

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

For more Informatica Interview Questions Click Here
Categories