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

Differentiate between joiner and lookup transformation?

0 Answers  

what is row level and column level indicator?

1 Answers   TCS,

Separate from an archive server and a powerhouse?

0 Answers  

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

What do you mean by enterprise data warehousing?

0 Answers  

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

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 Cognos script editor?

0 Answers   Cognizant,

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

What are the connected or unconnected transforamations?

2 Answers  

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

For more Informatica Interview Questions Click Here
Categories