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

I have 1200 records how can u send it in aggregator with
good performance issues?

Answer Posted / venkat

Provide sorted input before aggregation.
->Override default Sql from source Qualifier if the source
is relational-Use order by clause
(OR)
->Use Sorter transfermation to do the same

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sq transformation?

1164


Why is sorter an active transformation?

1131


How do you load only null records into target?

1217


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2126


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2038


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

1044


How to update or delete the rows in a target, which do not have key fields?

1180


What is the use of code page?

1097


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2344


How to update a particular record in target with out running whole workflow?

1578


What is a difference between complete, stop and abort?

1086


What are the tuning techniques you applied during your last project

2027


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1136


server hot-ws270 is connect to Repository B. What does it mean?

2567


what is $$$$?

2163