✅Lookup cache in Informatica IICS ✅ Dynamic lookup cache ✅ Persistent lookup cache ✅ Static cache

[@NICITACADEMY]

*Complete 48 hours of IICS - Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/ Are you interested in joining my Live training? or Self-Paced course? You can visit our website for more details. www.nicitacademy.com/ Contact me for more details @ 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Thanks, NiC IT Academy

[@venkateshmangamolla]

thanks for explaining

[@NICITACADEMY]

You're welcome

[@ashokdadhe8146]

Super

[@NICITACADEMY]

Thanks

[@ramyasri8272]

Topic clearly covered and well explained. If we have multiple columns in lookup table is it good to go with MD5(concatenation) for comparison?

[@NICITACADEMY]

Thanks, Yes, we can use MD5 function.

[@MsPallavi18]

To use persistent cache can we use mapping tasks across different taskflows?

[@juliburnwal9940]

What i in target table checksum field is not there how will we compare the values with source?

[@kalyand3959]

Hi sir, If possible make a replica of the real time work done using iics Thanks in advance sir

[@NICITACADEMY]

Due to a conflict of interest, we should not share any real-time work on the public forum. It is against compliance and copyright act. courses.nicitacademy.com/

[@kaustubhsawant9653]

Hello , I am recieving this below error : WRT_8229 Database errors occurred: FnName: Execute -- [Informatica][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint (KAUS.SYS_C0015216) violated . My update ran successfully ,but update and insert its throwing above error

[@SJPZKL]

Seems like you are trying to write to the target table with the duplicate record,