How does PBK and Sort component and Join(in memory sort) work?I mean in the joi

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

1 Answers
5128 Views
I also Faced
E-Mail Answers

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

Why might the optimizer use a table scan when an index is available?

0 Answers

Describe how you would monitor and control database physical file size and growth?

3 Answers IBM, Satyam,

How to add default rules in transformer?

0 Answers

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

0 Answers

What is the significance of record required indicator of Join component ? How to use in abinitio graph?

2 Answers IBM, TCL,

How we can remove temp files of a failed job if .rec is not available ? How to use in abinitio graph?

2 Answers IBM, TCL,

What are the different versions and releases of ABinitio ?

2 Answers

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

0 Answers

what is the use of stdenv in abinitio and what the main concept belongs to is?what is env?

1 Answers

Explain what does dependency analysis mean in abinitio?