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 dimensional table? Explain the different dimensions.

0 Answers  

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

How to use pmcmd utility command?

0 Answers  

what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  

What is target designer and target load order?

0 Answers  

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

Can you access a repository created in previous version of Informatica?

1 Answers  

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

For more Informatica Interview Questions Click Here
Categories