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

Answer Posted / kvikas2056

If you are using multiple look up transformations on same table, at that time you can use persistent named cache.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1526


what make u disappointmnets in u r career

1958


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2291


In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

708


what is Forward,Reverse and Re_engineering?

1955


What is initial load and what is full load?

676


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

712


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1645


When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

706


how do u really know that paging to disk is happening while u are using a lookup transform?

1732


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

1811


what is the difference between cubes and package in cognos

4718


Do we need an etl tool?

733


What is cube grouping?

742


what are the cubes developed in a sap bw project and what is the requirement for developing it?

1871