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.

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

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.

Answer / m

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

Answer / sreekanth

to eliminate duplicates also sorter transformation is used

What is the difference between Normal load and Bulk load?

5 Answers  

What is the function of aggregator transformation?

0 Answers  

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

Why we use lookup transformations?

1 Answers  

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

What is domain and gateway node?

0 Answers  

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

how to insert header after each group.

1 Answers   IBM,

What is the difference between router and filter?

0 Answers  

when we dont use aggregator in mapping ?

2 Answers   CSC,