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

How to extract sap data using informatica?

0 Answers  

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

0 Answers  

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

What is aggregate cache in aggregator transforamtion?

5 Answers  

can we override a native sql query within informatica? Where do we do it?

0 Answers  

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

what is session parameters?

1 Answers   Cap Gemini,

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  

What is the benefit of session partitioning?

0 Answers  

what is parallel querying and what r hints.

1 Answers  

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

For more Informatica Interview Questions Click Here
Categories