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

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

What are the ETL tools available in DWH?

6 Answers   Mphasis,

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

In which circumstances that informatica server creates Reject files?

2 Answers  

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

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

0 Answers   TCS,

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories