*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
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?
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 ?
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.
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
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. ua-cam.com/video/nSs5C0C1c64/v-deo.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
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
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
Such a detailed video.... great explanation sir...
Thank you. Keep watching my channel.
how to increase font size the way u did at 20:36 , not working ctrlA AND ctrl+, or is it different for different version
Thanks for video 😊
Welcome 😊
Very good explanation and really appreciate your efforts sir
Thanks and welcome
Please provide link sQL single row function link
ua-cam.com/video/4qJJxQuHLC4/v-deo.html
Thnq so much for your detailed explanation on each topic sir ..how can I get data for doing exercises??
Big big thnks to u....
Most welcome
Hello sir pls tell me which transformation is used to enter names in name column
Expression Transformation
@@NICITACADEMY Thank you sir
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?
Very nice explanation Thanks.. Expression Transformation notes not available in the description, Kindly provide for practice
I will update
From where we can get the example data which u are used in the videos
Please watch my installation video
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/
sir how to open the notes and exercise that you have provided in the link and thank you for the video.
Please Check description
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.
Hi sir , can you please provide link for SQL single row function video
I have already posted, please check the playlist.
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
Hi sir,
Please post the informatica interview questions and answers in one video
Ok sure
Sir , please upload all videos, in scd
Okay sure.
Please create video on following topics :
a. Cleaning the data
b. Reusability features
c. Command line utilities
d CDC and constraint based learning
Sure.
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 UA-cam
How to solve the Sum(salary) for all target table instead of salary
Please watch Aggregate functions in SQL: (To understand better)
ua-cam.com/video/sUU0ydjsJyA/v-deo.html
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.
ua-cam.com/video/nSs5C0C1c64/v-deo.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
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: ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
Tamil: ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
@nicitacademy
ua-cam.com/video/4qJJxQuHLC4/v-deo.html