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

Can we make worklet inside worklet?

1 Answers  


What is log file,and where is it located,why u r using the log file

1 Answers   TCS,


What do you understand by SOA of Informatica?

0 Answers  


Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,


What are different types of transformations available in informatica?

0 Answers  


What is data merging, data cleansing and sampling?

6 Answers   Satyam,


Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,


select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,


What are the types of schemas we have in data warehouse.

0 Answers  


What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  


Define sessions in informatica etl?

0 Answers  


if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  


Categories