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 |
in which situations do u go for scds ?
Which gives the more performance when compare to fixed width and delimited file ? and why?
where to store informatica rejected data? How to extract the informatica rejected data?
Can i create a lookup table without cache.
Explain transaction control transformation in informatica
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
How union transformation is used?
Could you explain what is enterprise data warehouse?
What are the components of Informatica? And what is the purpose of each?
What is the way to execute pl/sql script using informatica mapping?
How can you define user defied event?
When the informatica server marks that a batch is failed?