✅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.

[@juliburnwal9940]

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

[@MsPallavi18]

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

[@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,