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

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall?

Please answer below. thank you.

Question Posted / pradeep

Answers were Sorted based on User's Feedback



What if we sort the data in descending order instead of increasing order in sorter t/f and send the ..

Answer / harish

No performance downfall. Example: if your choosing sort order on deptno asc/desc and sal desc.

Is This Answer Correct ?    0 Yes 1 No

What if we sort the data in descending order instead of increasing order in sorter t/f and send the ..

Answer / sai

There is no performance difference while aggregation because Order by always comes after Aggregation.

Is This Answer Correct ?    0 Yes 1 No

What if we sort the data in descending order instead of increasing order in sorter t/f and send the ..

Answer / bharath yadav

after sorting data in sorter tf enable sorted input in aggregator tf for better performance . if the sorted data key in sorter tf and aggregator tf differs then session fails.

Is This Answer Correct ?    0 Yes 1 No

What if we sort the data in descending order instead of increasing order in sorter t/f and send the ..

Answer / me

If you use sorted input and do not sort data correctly, the session fails.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

What are the modules in Power Center

0 Answers  

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

What do you understand by SOA of Informatica?

0 Answers  

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,

What are the basic needs to join two sources in a source qualifier?

4 Answers  

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

checkout and checkin in informatica 8.6

3 Answers   TCS,

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

What is the difference between Normal load and Bulk load?

5 Answers  

Describe expression transformation?

0 Answers  

Explain joiner transformation in informatica

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories