how to calculate the optimum cache size in aggregator
transformation?
Answer / 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 |
Mention a few design and development best practices for informatica?
how to load rows into fact table in data warehouse
How to load time dimension?
What is sequence generator transformation in informatica?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
In update strategy target table or flat file which gives more performance ? why?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
What are the scheduling options to run a sesion?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
What are the performance considerations when working with aggregator transformation?