Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the advantage of persistent cache? when it should be
used?

Answer Posted / san

when the table you are using for lookup is static table(
i.e. data is not changing ) and it is the huge table.
Hence reduce the session time by using the persistent cache
file/s.
Regards,

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the etl testing operations includes?

1043


What are cubes and olap cubes?

917


What are the differences between sql override and update override?

1024


what is the use of structures?how many nodes can u create in a structure?

2170


What is tracing level?

1010


Explain the difference between etl tool and olap tools?

851


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?

1821


What are various etl tools in the market?

938


how many maximum session supports to multiload in teradata ??

2042


Explain etl mapping sheets?

1019


Explain about the data integration suite features?

877


Is hadoop a etl tool?

881


What is initial load and what is full load?

903


What is full load & incremental or refresh load?

1155


what is the main role of FI on business

2035