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 is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

What is the sequence generator transformation in informatica?

0 Answers  

Why do we need informatica?

0 Answers  

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

How can we use mapping variables in informatica?

0 Answers  

What do mean by local and global repository?

0 Answers  

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

what is data driven in informatica

5 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories