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 do you load first and last records into target table?
Why filter transformation is an active one?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
what is metadata?
How to improve the performance of a session using sorter transformation?
What does update strategy mean, and what are the different option of it?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
Can we use parameters of parameter file in presession command
How can repository reports be accessed without sql or other transformations?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
What is the difference between Normal load and Bulk load?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.