Informatica dynamic lookup cache not updating

*Filter candidates using Test Your and save 80% time ( saving time for recruiters and interviewers) *More than 50% candidates can be filtered on Candidate Screening online tests *Inbuilt exams are available in library, created and tested by experts Try Today... Answer: Parallel Processing is broadly classified into 2 types. Question: What is Modulus and Splitting in Dynamic Hashed File? Question: Have you ever involved in updating the DS versions like DS 5.

DATASTAGE Frequently asked Questions and Tutorials: 1. Answer: In a Hashed File, the size of the file keeps changing randomly. The often Parameterized variables in a job are: DB DSN name, username, password, dates W. X, if so tell us some the steps you have taken in doing so? The following are some of the steps: Definitely take a back up of the whole project(s) by exporting the project as a file See that you are using the same parent folder for the new version also for your old jobs using the hard-coded file path to work.

Answer: As the names itself suggest what they mean. The Data file has a default size of 2GB and the overflow file is used if the data exceeds the 2GB size. Question: Compare and Contrast ODBC and Plug-In stages? Question: What are OConv () and Iconv () functions and where are they used? Question: Functionality of Link Partitioner and Link Collector?

Derivation - Expression that specifies value to be passed on to the target column. B) Dynamic - sub divided into 2 types i) Generic ii) Specific Default Hased file is "Dynamic - Type Random 30 D" Question: What are Static Hash files and Dynamic Hash files? Answer: Container is a collection of stages used for the purpose of Reusability. A) Local Container: Job Specific B) Shared Container: Used in any job within a project. Answer: By using "Excec SH" command at Before/After job properties.

Since you can't generate ID's on Infa side, I would use a dummy Dim id to populate fact table (like -1) and run an update statement after the load is complete.

Sending the request for a key and getting the key from DB means a lot of DB calls - this takes time and will slow down the whole process a lot.

Answer: Stage Variable - An intermediate processing variable that retains value during read and doesn? Constraint - Conditions that are either true or false that specifies flow of data with a link. Question: What is Hash file stage and what is it used for? A) Static - Sub divided into 17 types based on Primary Key Pattern. Question: How to run a Shell Script within the scope of a Data stage job?

Question: What are Stage Variables, Derivations and Constants? We can increase it by going into Datastage Administrator and selecting the Tunable Tab and specify the cache size over there. It is also used in-place of ODBC, OCI tables for better performance. Answer: Hashed File is classified broadly into 2 types.

But when I run the mapping again, The informatica is taking the old value from the dynamic cache and not the updated value.

This means that the target table is updated correctly but at the same time the cache is not updated with the current value.

This makes both the target table and the Dynamic lookup cache not in sync.

Example : suppose the existing value of lookup dynamic cache is 100 and when the session updates the value as 120 in both cache and target.

Lets say i add another row with the same key but i update the description to my table.