Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5120 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
Can sorting and storing be done through single software or you need different for these approaches?
What are the Graph parameter?
Explain what is the architecture of abinitio?
What is local and formal parameter?
Mention what is rollup component?
Mention what is the syntax for m_dump in abinitio?
What is the purpose of having stored procedures in a database?
Explain what is de-partition in abinitio?
What kind of layouts does abinitio support?
Mention what the difference between “look-up” file and “look is up” in abinitio?
Explain the difference between the truncate and delete commands?
Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use
What are the types of data processing you are familiar with?
What are the different types of parallelism used in abinitio?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
