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
- 5127 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
What do you know about abinitio?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What are the operations that support avoiding duplicate record?
Mention what is rollup component?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
What do you know about partition and also tell us about partition components in abinitio?
How can you force the optimizer to use a particular index?
What are differences between different versions of co-op?
How can you export a component’s internal parameters ?
List out the file extensions used in abinitio?
What is a data processing cycle and what is its significance?
Can anyone give me an exaple of realtime start script in the graph?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
How can you import XML repositories exported from different tools like ODI
Have you used the rollup component? Describe how?
