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?



How does PBK and Sort component and Join(in memory sort) work?I mean in the join component i have u..

Answer / 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

More Ab Initio Interview Questions

How to calculate total memory used my a graph?

1 Answers   IBM,


How do you truncate a table?

0 Answers  


Order of Evaluation of Parameters

2 Answers  


How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

0 Answers  


I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

0 Answers  






How you can delete an object from a tag ? How to use in abinitio graph?

1 Answers   IBM, TCL,


what is the syntax of m_dump command?

3 Answers  


what is macro?At what situation we have to face?

1 Answers  


Mention what the difference between “look-up” file and “look is up” in abinitio?

0 Answers  


Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com

0 Answers  


What dedup-component and replicate component does?

0 Answers  


What is air-project parameter ?

0 Answers  


Categories