*Complete 48 hours of 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======================================================================= 🔵Oracle SQL Tutorial - English ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html 📌*IICS demo session:* ua-cam.com/video/C1zGVRFM3-A/v-deo.html 📌*Informatica Full Course:* ua-cam.com/video/V2FtZ_INmjg/v-deo.html 📌*SQL Full Course:* ua-cam.com/video/iuvzjf7nU1I/v-deo.html 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist ua-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html 🌕 Informatica training in ENGLISH - Playlist ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html 🌕 Informatica Interview Preparation - ENGLISH ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html 🌕Oracle SQL - தமிழில் ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html 🔵 Informatica training in தமிழில் - Playlist ua-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html 🔵 Informatica Interview Preparation - TAMIL ua-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html 🔵Unix for Informatica Developer ua-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html 🌕Informatica Project videos ua-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html Please subscribe, Like, and comment. I will post more videos. Thanks
Very clear explanation, excellent 👌 Thank You. Even paid training they did not cover these topics and you made it free. Thanks. Please add interview questions and answers.
While updating, lkp_cust_id should be mapped in target, right? Bcz in rcrd we won't ever be updating cust_id, and corresponding to lkp_cust_id we will be updating other fields
We do not update PK, by keeping PK, other attributes will be updated. Please watch my SCD Types session to understand completely. Keep watching my channel.
in this scd_1 with MD5 without expression also possible or not.. router to update expression md5 is given..but not given target lkp md5...why? what is use ofMD5(yash value)
Hi.. Reg Insert and update logic.. It seems in MD5 also we need to give more columns to check source vs Target like the older SCD 1 concept which you have explained before. Let's say if we have 100 columns in the look up and that has to be verified with the source.. I don't see any big difference here. Then what is the use of MD5 function so we can go with older concepts which u have explained during scd1 session. Please correct me if I am wrong.. thanks in advance
*Complete 48 hours of 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=======================================================================
🔵Oracle SQL Tutorial - English
ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
ua-cam.com/video/C1zGVRFM3-A/v-deo.html
📌*Informatica Full Course:*
ua-cam.com/video/V2FtZ_INmjg/v-deo.html
📌*SQL Full Course:*
ua-cam.com/video/iuvzjf7nU1I/v-deo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
ua-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
ua-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
ua-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
ua-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks
Very clear explanation, excellent 👌 Thank You. Even paid training they did not cover these topics and you made it free. Thanks. Please add interview questions and answers.
Glad it was helpful!
Most awaited video thanks sir🥳
Most welcome 😊
Thank you so much sir , waiting for this video
Most welcome
Wow, this is awesome, Thank you sir 🙏🙏. I have requested for this video a while ago.
You are most welcome, Keep watching my channel.
Excellent explanation, easy to understand .Thankyou
Glad it was helpful!. Keep watching my channel.
Your videos are always informative. Requesting to create a course on Informatica BDM
Noted. Keep watching my channel.
Can we not do scd type1,2 without update strategy , by enabling update a update and treat dev row as update option
Hiii sir .. please make video on incremental aggregation
As soon as possible
While updating, lkp_cust_id should be mapped in target, right? Bcz in rcrd we won't ever be updating cust_id, and corresponding to lkp_cust_id we will be updating other fields
We do not update PK, by keeping PK, other attributes will be updated. Please watch my SCD Types session to understand completely. Keep watching my channel.
in this scd_1 with MD5 without expression also possible or not..
router to update expression md5 is given..but not given target lkp md5...why?
what is use ofMD5(yash value)
yes possible.
Hash value changed fine but which column got changed how we know by looking into hash value of tgt from src
Hi.. Reg Insert and update logic..
It seems in MD5 also we need to give more columns to check source vs Target like the older SCD 1 concept which you have explained before.
Let's say if we have 100 columns in the look up and that has to be verified with the source.. I don't see any big difference here. Then what is the use of MD5 function so we can go with older concepts which u have explained during scd1 session.
Please correct me if I am wrong.. thanks in advance
yeah, It needs one time comparisons with MD5 function of the column names.
SIR YOUR EXPLANATION IS EXCLLENT SIR.. I WANT TO LEARN IICS SIR. FROM YOUR CHANNEL . WHAT CAN I DO SIR.
Please join my live training
📞For more details contact me on WhatsApp (+91 7010080468) or below link
wa.link/m4lat0
Please share SCD TYPE 2 IN ENGLISH LANGUAGE
I have already posted in English, please check the Informatica playlist