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

major difference between normal loading and bulk loading?

6 Answers  

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

What are the limitations of joiner transformation?

0 Answers   Informatica,

How to load time dimension?

1 Answers   Ford,

Why we need XMLs?

3 Answers   IBM,

what is the difference between stop and abort

2 Answers  

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

What are the new features of informatica 9.x developer?

0 Answers  

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

Explain lookup transformation is active in informatica

0 Answers   Informatica,

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

For more Informatica Interview Questions Click Here
Categories