How does PBK and Sort component and Join(in memory sort)
work?I mean in the join component i have used In Memory
Sort,so how will it work in terms of performence as
compared with PBKand Sort Component?

Answer Posted / kv

In-mermory sort always is useful for small amount of data to be sorted.
If the imput is already partioned on those keys as mentioned in join then in-memory sort will work incase of small amunt of data.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the ab initio etl tool in high level?

664


What are the key elements of a data processing system?

684


What are the co> operating system’s assorted library of integrated components?

650


What are the differences between different versions of co-op?

568


What are the features of ab initio?

625






What does edp stand for?

731


difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2302


What does it mean by the term 'sort component'?

674


What are the steps to create a repository in ab initio?

748


How would you find out whether a sql query is using the indices you expect?

598


What is the difference between check point and phase?

680


Mention how can you connect eme to abinitio server?

858


What are differences between different versions of co-op?

631


Mention what is abinitio?

594


explain the environment varaibles with example?

621