how to calculate the optimum cache size in aggregator
transformation?
- 1 Answers
- 7132 Views
- I also Faced
- E-Mail Answers
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 |
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
What is CDC? How to implement CDC?
What are Dimensions and various types of Dimensions?
What is the function of union transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
without table how to come first record only in oracle?
What is the difference between a table and the materialized view?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
In how many ways we can create ports?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
Teradata 
