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?
- 1 Answers
- 4318 Views
- I also Faced
- E-Mail Answers
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
The methods to improve performance of a graph?
What is data mapping and data modelling?
What is the purpose of having stored procedures in a data-based?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
How to create a repository in abinitio for stand-alone system(local nt)?
How does the bre work with the co>operating system?
State the working process of decimal_strip function?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What do you mean by the term data warehousing?
Have you used the rollup component? Describe how?
What the difference between “look-up” file and “look is up” in abinitio?
Explain the difference between the truncate and delete commands?
what is the output when -1 is put in select_expr of FBE?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
