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

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

How informatica process data means how informatica works?

2 Answers   TCS,

What is rank transformation?

0 Answers  

What aer the out put files that the informatica server creates during the session running?

4 Answers  

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

what is degenerated dimension table with scenario

2 Answers   HCL,

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,