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

)what is wrapper script?where it is going to execute and why we go for wrapper?

1 Answers   Satyam,

What is sandbox?

0 Answers  

What are the reasons for which business can trust the approach of data processing?

0 Answers  

i need help from u. i want to learn abinitio. please provide pdfs or material or books.

56 Answers   iGate, TCS,

Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...

1 Answers  




How do we handle if DML changing dynamicaly?

5 Answers   GE, HP, IBM, Mannar Company,

from a graph how to select only second record always in scan?

3 Answers   IBM,

How to calculate total memory used my a graph?

1 Answers   IBM,

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

0 Answers  

How to move data from developement to testing and testing to production?

1 Answers   BitWise, CTS, Satyam, Wipro,

In abinitio, what types of parallelism are used?

0 Answers  

Describe what the SQL Server tempdb and tlog files are used for?

0 Answers  

For more Ab Initio Interview Questions Click Here
Categories