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...


What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?



What is the expected value if the column in an aggregator transform is neither a group by nor an agg..

Answer / ysindhureddy77@gmail.com

If we do not use an input port in group-by neither in aggregate expression, the Integration Service
will return only the last row value of the column for the input rows.
For example, if we have 100 rows coming from source then aggregator will output only the last record (100th
record)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,


I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,


What is the difference between Normal load and Bulk load?

5 Answers  


How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  


What is the default join that source qualifier provides?

3 Answers   Informatica,


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  


wf dont have integration severances how you can run?

0 Answers   TCS,


My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,


without update strategy how to insert &update?

1 Answers   DELL,


In informatica workflow manager, how many repositories can be created?

0 Answers  


What are the advantages of using informatica as an etl tool over teradata?

0 Answers  


What are the session parameters?

3 Answers  


Categories