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 union transformation?

0 Answers  

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

What is Cognos script editor?

0 Answers   Cognizant,

Explain about HLD and LLD ?

16 Answers   Accenture,

Briefly define reusable transformation?

0 Answers  

How to configure mapping in informatica?

0 Answers  

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,