what are Lookup caches options? Including persistent caches.
Answer Posted / abhishek.x.upadhyay
There are two types of Lookup Cache options -
1. Dynamic cache.
2. Persistent cache
1. dynamic Cache - The Dynamic cache is a property of the
look up which if selected makes other ports of the same
record to be checked as Look up apart from the Look up port.
2. Persistent Cache - persistent cache is something like on
the first run the lookup table values gets into a cache and
is stored on the server's hard disk. Each time the run is
made the values would be looked up from this cache only.
Persistent cache is done only when the lookup has to be
made on same set of values each time.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What is data modeling and data mining?
dimension object created in oracle can be imported in designer?how?
What is the difference between Data Warehousing and Data Mining?
Explain about round-robi?
Define slowly changing dimensions (SCD)?
can cubes contain measures ?
how do use session mapping parameters ?(in which transformation)
what are the types in error loging?
what is the use of server manager?
Can u access a repository created in previous version of Informatica?
What is lookup table in etl testing?
Is apache nifi an etl tool?
Explain about enterprise scalability and roi of data integration suite?