how to calculate the optimum cache size in aggregator
transformation?
Answer Posted / sarvesh
in aggregator
data cache size is:
no.of groups(sigma(colomnsize)+7)and same for index
cache also
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Define filter transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is rank transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How does the aggregator transformation handle null values?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to use pmcmd utility command?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
In development project what is the process to follow for an etl developer from day1
What do you mean by channel change?
Explain what are the different versions of informatica?
What is exclusive and normal mode for repository services?