*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
Hi, I have implemented the scd type2, on running a workflow for the existing record in target, informatica is inserting new record. May i know what may went wrong here?
For updt udpt do i need to pull the key from updt strategy transformation to the target? We are only updating the end date for the updated record so connecting the key to the target from the update strategy transformation is not required I guess.
Can a Table have both SCD1 & SCD2 attributes associated with it..! Or Do we maintain seperate Tables for SCD T1~and SCD T2. I mean, Eg: EMP Table has Id, Name, Designation, location, salary. Can we have SCD1 on Designation and SCD2 on Location..?
*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
Thank you for the wonderful explanation Sir!!
Thank you Sir, Very clear keep doing more.
Welcome. sure I will do. Keep watching my channel.
Good explanation, Thank you Sir for posting the video !!!
You are welcome
your explanations are clear
Thank You
Clear explaination ,thank you
You are welcome
Hello sir
While executing code in core schema of lookup override it shown error'invalid relational operation'
Sir, is incremental load inbuilt wizard provided by Informatica not for trial version?
we have template in trial version as well.
Hi,
I have implemented the scd type2, on running a workflow for the existing record in target, informatica is inserting new record. May i know what may went wrong here?
use filter with condition src_checklkp_checksum
For updt udpt do i need to pull the key from updt strategy transformation to the target? We are only updating the end date for the updated record so connecting the key to the target from the update strategy transformation is not required I guess.
With that key value only Informatica knows which record needs to be updated.
Super session
Thank You
Can a Table have both SCD1 & SCD2 attributes associated with it..!
Or Do we maintain seperate Tables for SCD T1~and SCD T2.
I mean,
Eg: EMP Table has
Id, Name, Designation, location, salary.
Can we have
SCD1 on Designation and SCD2 on Location..?
Hello Sir,
In scd2 date, how to generate timestamp in eff/end date field of target?
Systimestamp
Sir, please do one session on session and properties complete tutorial please
why customer id is not null for new record
customer_id is null in target for new customer
when will you start new batch
please send me mail nicitacademy@gmai.com
I will send the details.
Sir, could you pls make videos on scd type 2 flag and version methods as well.
Sure, keep watching my channel.
If there is any new record in 2nd day will it load ?
Yes, It be inserted.
in real time we are having 300 to 400 columns we have write manually any other other way in scd lookup
Use MD5 function
can you upload scd mappings using md5 function
Sure I will do.
please explain real time project sir in informatica developer
Sure I will add videos
*operator
4035 sql error vasthundi
please share more information
ok issue resolved (some wrong connections )