If u r using dynamic cache lookup port will be thier in
thet which option u will select
Answer / santhosh
we need to select update else insert/insert else update option in lookup properties tab when we r using dynamic lookup cache.
| Is This Answer Correct ? | 0 Yes | 0 No |
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
How to do Integration testing in Informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
What is workflow monitor?
What is the surrogate key?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
what are the transformations that restricts the partitioning of sessions?
how can i invoke pmcmd in command line prompt
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..