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...


how can we use sorter transformation in joins?

Answers were Sorted based on User's Feedback



how can we use sorter transformation in joins?..

Answer / prasuna

You can improve session performance by configuring the
Joiner transformation to use sorted input.

To configure a mapping to use sorted data, you establish and
maintain a sort order in the mapping so the Integration
Service can use the sorted data when it processes the Joiner
transformation.

Is This Answer Correct ?    13 Yes 3 No

how can we use sorter transformation in joins?..

Answer / x

Hi,

In joiner T/S properties we have an option called sorter
input.
So by using this we can improve the session Performance

Is This Answer Correct ?    9 Yes 3 No

how can we use sorter transformation in joins?..

Answer / rakesh

while using the option sorted input, we must have to use sorter t/r before joiner to send the sorted data to the joiner.

Is This Answer Correct ?    6 Yes 0 No

how can we use sorter transformation in joins?..

Answer / m

To improve the perfomance we have to check the button "sorted input" ,

Is This Answer Correct ?    2 Yes 0 No

how can we use sorter transformation in joins?..

Answer / sreekanth

to eliminate duplicates also sorter transformation is used

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,


What are the phases in SDLC?

3 Answers  


Why we use partitioning the session in informatica?

2 Answers  


How do you load only null records into target? Explain through mapping flow.

0 Answers  


explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,


What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,


Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  


how to use incremental load?

2 Answers   TCS,


Can we use parameters of parameter file in presession command

1 Answers   Wipro,


How to recover the standalone session?

2 Answers  


What is the Difference between sorter and aggregator?

2 Answers  


How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,


Categories