*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
When I first entered IPC, I was overwhelmed by the number of windows, buttons, and lines. But you sir, you shed light on the whole process for me so clearly that now I understand it much better, thank you for sharing your experience and knowledge.
Thank you so much for the amazing explanation! I've taken a 4 month course on Powercenter, and I left feeling so confused. Our instructor always said 'just practice and you'll understand', but so many transformations I couldn't practice with my own scenarios because the logic wasn't explained. Now I'm going through all your videos and it makes so much more sense.
sir, does after processing all records at each transformation then forward the records to next transformation? or it it bunch wise or sequentially moved to next level transformation?
How to convert by using decode function in informatica power center the below scenario Gender column contains an F or M, this will need to be changed to Female and Male or UNK for row that is not F or M
Hello,there are some videos in the channel which are in tamil if possible may you add English translation for the same.I have almost watched all the English videos they make topic very esy to grasp.
Sir, how to remove trailing zeroes from decimal numbers ?? Eg 25.10000 we have to remove trailing zeroes from this number, which function should be used ?
How to list the employees into two tables where one of the tables contains employees with age greater than 25 and the other table contains employees with age less than 25?
Please use router transformation, create two groups in router, age25. If age is not a direct column, use DOB column to find age and segregate. Please watch my router transformation in the playlist. th-cam.com/video/nSs5C0C1c64/w-d-xo.html
No filter, because you need to use two filter transformation. Instead of filter, you can use Router Transformation, Please watch my router transformation video. I have explained this concepts. Thanks,
Hello sir, The link of the exercise that you have given in the description is not working. How to open it?. Please update it. Thanks in advance ☺️. You're lecture are awesome 👌
*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
When I first entered IPC, I was overwhelmed by the number of windows, buttons, and lines. But you sir, you shed light on the whole process for me so clearly that now I understand it much better, thank you for sharing your experience and knowledge.
You are welcome!
Thank you so much for the amazing explanation! I've taken a 4 month course on Powercenter, and I left feeling so confused. Our instructor always said 'just practice and you'll understand', but so many transformations I couldn't practice with my own scenarios because the logic wasn't explained. Now I'm going through all your videos and it makes so much more sense.
You're very welcome!
Very Useful, Nice Explanation 🙌
Thank you for watching!
Very Cristal clear explanation sir,tq so much
You are welcome
Thank you so much sir for explain everything in detail. God bless you sir.
You are most welcome
Very useful information for learners..
Thanks a lot
how to increase font size the way u did at 20:36 , not working ctrlA AND ctrl+, or is it different for different version
Such a detailed video.... great explanation sir...
Thank you. Keep watching my channel.
Very good explanation and really appreciate your efforts sir
Thanks and welcome
Thnq so much for your detailed explanation on each topic sir ..how can I get data for doing exercises??
Thanks for video 😊
Welcome 😊
sir, does after processing all records at each transformation then forward the records to next transformation? or it it bunch wise or sequentially moved to next level transformation?
How to convert by using decode function in informatica power center the below scenario
Gender column contains an F or M, this will need to be changed to Female and Male or UNK for row that is not F or M
Hello sir pls tell me which transformation is used to enter names in name column
Expression Transformation
@@NICITACADEMY Thank you sir
Very nice explanation Thanks.. Expression Transformation notes not available in the description, Kindly provide for practice
I will update
Big big thnks to u....
Most welcome
Hello,there are some videos in the channel which are in tamil if possible may you add English translation for the same.I have almost watched all the English videos they make topic very esy to grasp.
Hi Sure, Kindly keep watching my channel, I will add in English ASAP. Please refer to your friends. Thanks for your comments and feedback.
From where we can get the example data which u are used in the videos
Please watch my installation video
Please provide link sQL single row function link
th-cam.com/video/4qJJxQuHLC4/w-d-xo.html
sir how to open the notes and exercise that you have provided in the link and thank you for the video.
Please Check description
Sir, how to remove trailing zeroes from decimal numbers ??
Eg 25.10000 we have to remove trailing zeroes from this number, which function should be used ?
You can use LPAD or regular expression replace for complex logic
hi, I couldn't find the exercises? please help
Please get complete material from here
courses.nicitacademy.com/
Hi sir , can you please provide link for SQL single row function video
I have already posted, please check the playlist.
Please create video on following topics :
a. Cleaning the data
b. Reusability features
c. Command line utilities
d CDC and constraint based learning
Sure.
Hi sir,
Please post the informatica interview questions and answers in one video
Ok sure
How to list the employees into two tables where one of the tables contains employees with age greater than 25 and the other table contains employees with age less than 25?
Please use router transformation, create two groups in router, age25.
If age is not a direct column, use DOB column to find age and segregate.
Please watch my router transformation in the playlist.
th-cam.com/video/nSs5C0C1c64/w-d-xo.html
Thank you💕
@@NICITACADEMY can we use filter transformation for this question?
No filter, because you need to use two filter transformation. Instead of filter, you can use Router Transformation, Please watch my router transformation video.
I have explained this concepts.
Thanks,
Yes sure, Thanks. 💕
Hello sir,
The link of the exercise that you have given in the description is not working. How to open it?.
Please update it.
Thanks in advance ☺️.
You're lecture are awesome 👌
please contact me for more details.
nicitacademy@gmail.com
How to solve the Sum(salary) for all target table instead of salary
Please watch Aggregate functions in SQL: (To understand better)
th-cam.com/video/sUU0ydjsJyA/w-d-xo.html
any update on missing videos 6,7,8 and 9
Thanks, it will be uploaded
Can I get the link for those videos Sir I'm unable to find in TH-cam
Sir , please upload all videos, in scd
Okay sure.
Sir expression notes not open , they asking password sir
please check the description for password
There are so many videos in Tamil.
Please add English subtitles.
We can understand it.
I have already posted same videos in English please check the playlist
Single row functions link please
Please check the below
English: th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
Tamil: th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
@nicitacademy
th-cam.com/video/4qJJxQuHLC4/w-d-xo.html