*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 th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html 📌*IICS demo session:* th-cam.com/video/C1zGVRFM3-A/w-d-xo.html 📌*Informatica Full Course:* th-cam.com/video/V2FtZ_INmjg/w-d-xo.html 📌*SQL Full Course:* th-cam.com/video/iuvzjf7nU1I/w-d-xo.html 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist th-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html 🌕 Informatica training in ENGLISH - Playlist th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html 🌕 Informatica Interview Preparation - ENGLISH th-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html 🌕Oracle SQL - தமிழில் th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html 🔵 Informatica training in தமிழில் - Playlist th-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html 🔵 Informatica Interview Preparation - TAMIL th-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html 🔵Unix for Informatica Developer th-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html 🌕Informatica Project videos th-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html Please subscribe, Like, and comment. I will post more videos. Thanks
I was able to redo the same transformation but i see one issue every time i restart the task all the records are getting added to target table. for example if i update one record instead of adding one row in target table all the records are getting added along with existing records. i checked the lookup sql override, if i run that query i see only max version records. can you please help me on this?
i See that records are getting doubled every time i restart the task. i checked looked SQL override. its picking only max version records. can you help me on this please?
Hi Sir, thank you so much for this video, I have one interview question, if scd type 1 already running in production, and client want change it to scd type 2, so is it possible to change, if so what are impact will happen and how to implement. Kindly give some idea.
kindly guide me to install third party jdbc driver(postgres) oracle developer. whi;e testing the connection this error message shows. status : failure -connection to localhost:5432 refused. check that the hostname and port are correct and that the postmaster is accepting tcp/ip connections.
I feel this is incomplete, you are inserting the updated record, but where are you maintaining the history, the old version is not being written in the table, there should be a 3rd pipeline where you "close" the record with the original lkp_version and the sk id coming from the lookup
It's complete and correct only. Updated record inserted with new version, old record(history)already loaded with earlier vesion. Refer the example given in the end.
SELECT scd_type_2.ID_key as ID_key, scd_type_2.NAME as NAME, scd_type_2.CITY as CITY, scd_type_2.VERSION as VERSION, scd_type_2.ID as ID FROM scd_type_2 where (scd_type_2.ID as ID, scd_type_2.VERSION as VERSION)in (select scd_type_2.id AS id ,max(scd_type_2.version AS version) from scd_type_2 group by scd_type_2.id AS id); what is the problem in this query ........... i m getting invalid relational operator
*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
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
th-cam.com/video/C1zGVRFM3-A/w-d-xo.html
📌*Informatica Full Course:*
th-cam.com/video/V2FtZ_INmjg/w-d-xo.html
📌*SQL Full Course:*
th-cam.com/video/iuvzjf7nU1I/w-d-xo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
th-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
th-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
th-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
th-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
th-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks
Nicely explained.!!
Thank you! 🙂
very nicely explained .Can u pls post the flag method as well for SCD2
Yes, sure
I was able to redo the same transformation but i see one issue every time i restart the task all the records are getting added to target table. for example if i update one record instead of adding one row in target table all the records are getting added along with existing records. i checked the lookup sql override, if i run that query i see only max version records. can you please help me on this?
i See that records are getting doubled every time i restart the task. i checked looked SQL override. its picking only max version records. can you help me on this please?
Thank you for r explain ,please do scd type 2with effective date approach
I have already posted SCD type -2 date method, please check playlist.
Hi Sir, thank you so much for this video, I have one interview question, if scd type 1 already running in production, and client want change it to scd type 2, so is it possible to change, if so what are impact will happen and how to implement. Kindly give some idea.
kindly guide me to install third party jdbc driver(postgres) oracle developer.
whi;e testing the connection this error message shows.
status : failure -connection to localhost:5432 refused. check that the hostname and port are correct and that the postmaster is accepting tcp/ip connections.
I feel this is incomplete, you are inserting the updated record, but where are you maintaining the history, the old version is not being written in the table, there should be a 3rd pipeline where you "close" the record with the original lkp_version and the sk id coming from the lookup
It's complete and correct only. Updated record inserted with new version, old record(history)already loaded with earlier vesion. Refer the example given in the end.
Hi sir,
Is it mandatory dim_key in scd type2?
Without dim_key can we design scdtyp2 ? Then how plz suggest to me
Yes we can design, since there is no update logic.
Is this customer_key is surrogate key here?
Yes correct
SELECT scd_type_2.ID_key as ID_key, scd_type_2.NAME as NAME, scd_type_2.CITY
as CITY, scd_type_2.VERSION as VERSION, scd_type_2.ID as ID FROM scd_type_2
where (scd_type_2.ID as ID, scd_type_2.VERSION as VERSION)in
(select scd_type_2.id AS id ,max(scd_type_2.version AS version)
from scd_type_2 group by scd_type_2.id AS id);
what is the problem in this query ........... i m getting invalid relational operator
remove the alias name in the where condition,
always run the query in SQL developer and check.
Hii sir pls provide videos in telugu
Telugu kadu bro anthanu