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

If we are using an aggregator but forget to mention the
group by port .what will be the output??

Answer Posted / vikneswaran

output is single record.for examples

col1
1
1
1
2
2
2
3
3
4
if i use group by and sum(col1) ...
output
col1
3
6
6
4
if i didn't use group by but same agg function
output
col1
19

Is This Answer Correct ?    10 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Whats the difference between informatica powercenter server, repositoryserver and repository?

1178


Explain the aggregator transformation?

1169


What is event and what are the tasks related to it?

1122


draw informatica architecture 8.6 ?

3874


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2038


What is lookup change?

1052


Which transformation is needed while using the Cobol sources as source definitions?

1177


What do you understand by a term domain?

1125


What are the performance considerations when working with aggregator transformation?

1155


What is the sequence generator transformation in informatica?

1185


How many ways are there to create ports?

1335


Why update strategy and union transformations are active? Explain with examples.

1243


What are batches?

1102


what is size of u r database?

2311


Explain scd type 3 through mapping.

1021