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?

Answers were Sorted based on User's Feedback



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

Answer / kishore

Before aggrgator transformation it's better to use Sorter
transformation, which will make them as sort, which will
increse the performance.

Is This Answer Correct ?    7 Yes 0 No

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

Answer / drk

By using sorted input and group by function ,we can overcome
the performance issues

Is This Answer Correct ?    3 Yes 0 No

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

Answer / 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

More Informatica Interview Questions

what is fact table?

9 Answers  


Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,


can u give example for factless fact table

2 Answers   TCS,


What is target update override

2 Answers   CTS,


Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,


what is the difference between static and dynamic

4 Answers   TCS, Wipro,


Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,


how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,


Mention few power centre client applications with their basic purpose?

0 Answers  


What is router transformation

4 Answers   CSC,


what is Active lock explain

0 Answers   Satyam,


can every transfomation reusable?how?

2 Answers   Wipro,


Categories