Answer Posted / krushna
Static lookup gets loaded in memory while running graph and remains in memory till the complete execution of graph even if you have not used any lookup functions in transform or graph.
But dynamic lookup gets loaded only when lookup function is encountered. This results in save memory and improve performance. You can load lookup whenever needed and unload it. For dynamic lookup abinitio has LOOKUP TEMPLATE component.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What exactly do you understand with the term data processing and businesses can trust this approach?
What are the six data process products of ab initio (architecture of ab initio)?
What are the different types of parallelism used in abinitio?
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?
explain checkin and checkout?
What is the purpose of having stored procedures in a data-based?
What is MAX CORE of a component?
What does de-partition mean in abinitio?
Within a cursor, how would you update fields on the row just fetched?
Why do you think data processing is important?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
State the relation between EME, GDE and Co-operating system?
What a local lookup is?
What are the different forms of output that can be obtained after processing of data?
What do you mean by the term data warehousing? Is it different from data mining?