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 new features of informatica 9.x in developer level?

0 Answers  

How to improve the session performance in informatica?

3 Answers   Accenture,

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

How do you implement scheduling in Informatica?

1 Answers  

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

what is incremental data aggregation?

3 Answers   IBM,

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

What are the databases that informatica can connect to windows?

0 Answers  

How can we create index after completion of load process?

0 Answers  

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  

For more Informatica Interview Questions Click Here
Categories