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 are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

What is a design?

1 Answers  

What is IQD file?

1 Answers  

What is source qualifier transformation?

1 Answers  

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

What is surrogate key?

9 Answers  

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  

Implementation methodology

0 Answers