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 are the limitation of sorter transformation?

Question Posted / mahidar.chinna

Answers were Sorted based on User's Feedback



what are the limitation of sorter transformation?..

Answer / shiva

limitation is with the sortor cache. the following are its
limitations....
In version 8 it is set to Auto. In version v7 it is 8MB
If it cannot allocate then the session will fail
If it needs more memory that it will pages the data in the
Work Directory, and writes a warning in the log file.

let me know to what extent the answer is correct..

Is This Answer Correct ?    1 Yes 0 No

what are the limitation of sorter transformation?..

Answer / rayudu

the limitation of sorter t/r is cache
in informatica 8 it is default auto...

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is staging area?

11 Answers  

What are the join types in joiner transformation?

1 Answers   Informatica,

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  

Differentiate between reusable transformation and mapplet.

0 Answers  

Is it possible to use a client with different version than that of its Informatica server?

0 Answers  

What is diff joiner and lookup

4 Answers   BirlaSoft,

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories