What is difference between lookup cashe and unchashed lookup?Can i run the mapping with out starting the informatica server?

  • Interview Candidate
  • 2
  • 2237

Showing Answers 1 - 2 of 2 Answers

madhu

  • Mar 1st, 2006
 

the difference between cache and uncacheed lookup iswhen you configure the lookup transformation cache lookup it stores all the lookup table data in the cache when the first input record enter into the lookup transformation, in cache lookup the select statement executes only once and compares the values of the input record with the values in the cachebut in uncache lookup the the select statement executes for each input record entering into the lookup transformation and it has to connect to database each time entering the new record

sn3508

  • May 12th, 2008
 

for 1st question, the above answer is correct.

for 2nd, NO, you are even unable to connect to the repository if informatica server is not started.  As such, no question of viewing your workflow and running it.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions