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
- 5979 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 |
how to create a sample mapping for dynamic lookup transformation
In which circumstances that informatica server creates Reject files?
tell me the push down optimization
what is flat file override?
can we use self join in informaitca?
How you can differentiate between connected lookup and unconnected lookup?
What are partitions in informatica and which one is used for better performance?
what is mapping override?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
Enlist the differences between database and data warehouse.
Can we combine a flatfile and a database table using an UNION transformation?
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.
Teradata 
