Interested to Buy Any Domain ? << Click Here >> for more details...
what is the max/min size allocated for caches.whether index
or datacache in any of the transformations like Joiner or
Aggregator.bcoz it is set to Auto by default which means we
need not to allocate no of bytes or MB.so what is the use of
these properties.please let me know about the caches.
Thnaks in advance
Sai Ram
- 3 Answers
- 7057 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivas bolusupati
Data cache size is between 2MB to 24MB.
Index cache size is between 1MB to 12 MB.
| Is This Answer Correct ? | 3 Yes | 0 No |
INDEX CACHE IS MIN IN SIZE AND DATA CACHE IS MAX IN SIZE
| Is This Answer Correct ? | 0 Yes | 0 No |
MIN SIZE FOR INDEX CACHE IS 1MB
N DAT OF DATA CACHE IS DOUBLE OF THAT
IN AGGREGATOR..THE AUTO PROPERTY PERFORMS THE FOLLOWING
FUNCTION...
SUPPOSE WE HAVE CHOOSED THE SIZE TO BE 8 MB N THE SESSION
UTILIZES ONLY 3 MB SO IF WE SET THE PROPERTY TO AUTO IT WILL
SET THE CACHE SIZE AUTOMATICALLY TO 3MB.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
What is the Process to creating lookup transformation in informatica
What are the diffrences between joiner transformation and source qualifier transformation?
How can you run a session without using server manager?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
what is the difference between copy object import objects using repositery manager which one is best
Teradata 
