Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Ab Initio
  2. Suggest New Category

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?

Question Posted / binay bhusan mishra


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 we can remove temp files of a failed job if .rec is not available

2 Answers  

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

0 Answers  

How can you view the data in the Multifile

4 Answers   IBM,

What is the difference between partitioning with key and round robin?

7 Answers   TCS, Wipro,

Mention what is abinitio?

0 Answers  

What are the Types of parallelism in detail?

0 Answers  

Mention what are the different types of parallelism used in abinitio?

0 Answers  

. How can you get all the fields form a lookup files ? (Which function)

3 Answers   TCL,

What is a look-up?

0 Answers  

What is max core value ? what is the use of it?

2 Answers   JPMorgan Chase, Wipro,

What do you understand by a cartesian join?

0 Answers  

What is the latest version that is available in Ab-initio?

14 Answers   TetraSoft,

For more Ab Initio Interview Questions Click Here
Categories