Informatica Tutorial | Update Strategy transformation | Slowly Changing Dimension (SCD) Type 1 |

[@NICITACADEMY]

*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 NiC IT Academy ======================================================================= 🔵Oracle SQL Tutorial - English kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 📌*IICS demo session:* kzbin.info/www/bejne/eWLdeImIe7JmY6M 📌*Informatica Full Course:* kzbin.info/www/bejne/jGOppY2VfrOgoMk 📌*SQL Full Course:* kzbin.info/www/bejne/n6bZq52cbNOIZ6s 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj 🌕 Informatica training in ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd 🌕 Informatica Interview Preparation - ENGLISH kzbin.info/aero/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d 🌕Oracle SQL - தமிழில் kzbin.info/aero/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 🔵 Informatica training in தமிழில் - Playlist kzbin.info/aero/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3 🔵 Informatica Interview Preparation - TAMIL kzbin.info/aero/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD 🔵Unix for Informatica Developer kzbin.info/aero/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw 🌕Informatica Project videos kzbin.info/aero/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6 Please subscribe, Like, and comment. I will post more videos. Thanks

[@saivasepalli6008]

Detailed video to understand update strategy. Thank you sir for sharing your knowledge. Keep radiating informatica knowledge.🍀🌄

[@NICITACADEMY]

Thank you. Keep watching my channel

[@allialli281]

Very nice explination each and every vedio understandble

[@NICITACADEMY]

Thanks and welcome

[@Technical_ground]

Hello sir , I have a strong desire to document this. I've been grappling with implementing SCD Type 1 in my current project for three months now. However, today, I successfully crafted the mapping by closely following a video tutorial. I'm immensely grateful for your guidance, sir. Thank you.

[@chinns6072]

very good explanation

[@NICITACADEMY]

Glad you think so!

[@rajvaibhavtawadkar164]

Grate explanation sir 🤩

[@NICITACADEMY]

Thanks and welcome

[@prithviaustin9552]

@NICITACADEMY How to do insert and update on target without primary key ? Like incase there is no primary key defined on target table on DB level ? But in informatica we have some 5columns defined to be PK in requirement?

[@NICITACADEMY]

I ll add one video on this

[@preronasanyal6666]

Sir, in this one, even after having data in the source table, in the workflow monitor it is showing succeeded also, but the statistics is showing as 0 records in the source and 0 records in the targets as well.

[@NICITACADEMY]

Please check whether you have committed the transaction after insert or updated in source.

[@preronasanyal6666]

@@NICITACADEMY okay sir..yes I think I had not committed after insert that's the reason...after commit again I have to do the mapping from the starting?

[@preronasanyal6666]

@@NICITACADEMY yes sir, now I committed the insert statement in sql, and then now it is showing properly...thank you so much sir for the quick response.

[@NICITACADEMY]

Good, Keep watching my channel.

[@sripriyaaruru2697]

Hello, sir, your vedios are so simple and more informative, can you make vedio to teach about insert and delete in update strategy in scd3, thank you

[@NICITACADEMY]

Hi, I have already uploaded video on SCD Type 2, Please check the playlist.

[@nxashraf7266]

What is the difference between Update Stargey and SCds

[@NICITACADEMY]

Update strategy is a transformation, and SCD is a concept and it uses Upd Strategy transformation.

[@neharoy6859]

Can someone pls explain .How to update using update strategy transformation without a primary key in the target? like is it even possible to update without primary key ?

[@rajvaibhavtawadkar164]

Sir Please make also video on scd type 2 and 3😇 with md5 function

[@NICITACADEMY]

Hi.. I have already posted. Please check the playlist.

[@rajvaibhavtawadkar164]

@@NICITACADEMY sir it is in tamil but I cannot understand tamil that's why I want to explanation in English and other viewers also Thank you for your precious Time ♥️

[@vihangbahadure9908]

@@NICITACADEMY hi can you please share the link here not getting that video SCD type 2 in english

[@neharoy6859]

Can u pls explain .How to update using update strategy transformation without a primary key in the target?

[@vineethmenon2372]

i think in scd tpy1 primary key is not necessary in target

[@priyankan5987]

Table is created in target table but got error like view or table doesn't exist

[@INRI2025]

Generate sql execute then it will store in database

[@ANILKUMAR-xp1xj]

course fee

[@NICITACADEMY]

for more details, Please contact [e-mail]