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 |
How can you recover the session in sequential batches?
What are the challenges of Dataware housing in the future?
what is the size of your data warehousing?
can you use flat file for lookup table?why?
What are conformed dimensions?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How many numbers of sessions can one group in batches?
Enterprise data warehouse your projects phase by phase explain?
To provide support for Mainframes source data,which files r used as a COBOL files
Is there any model difference between ODS and DWH
Do joiner transformation use cache? If so describe?
What are the different clients of powercenter?