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

In development project what is the process to follow for an etl developer from day1

0 Answers  

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

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

4 Answers   Virtusa,

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

Differentiate between reusable transformation and mapplet.

0 Answers  

For more Informatica Interview Questions Click Here
Categories