Expression Transformation in Informatica | Informatica tutorial for beginners

#Informatica#informaticatutorial#informaticapowercenter#informaticatransformations
Expression Transformation in informatica
Informatica interview questions and answers in expression transformation
========================================================
🌕Want to join WhatsApp Group? (Only technical discussion, no spam messages, no promotion msg)
📌Informatica PowerCenter
github.com/nic...
📌IICS
github.com/nic...
========================================================
🌕 If you need self-paced complete Informatica ETL developer training batch recorded sessions - 35 days session(Paid) with all notes, Sample Resumes, interview questions and answers, Day wise exercise and 100 case studies questions (Paid), please write to [e-mail]/ or WhatsApp me @7010080468
📌 Day wise training session day 1 to 35 complete training, 35 hours
📌 All the day wise notes, exercises for practice, QA for interview
📌Resume preparation session - with 6 sample resumes
📌Roles and responsibilities session
📌Interview preparation session - Interview QA documents
📌Complex scenario session
📌Project architecture session
📌Interview questions and answers session
📌Life time access - no need to download
Please write to [e-mail]/ or WhatsApp me @7010080468
========================================================
🌕 Informatica training in ENGLISH - Playlist
• Informatica Training S...
🔵 Informatica training in TAMIL - Playlist
• Informatica Training -...
🌕 Informatica Interview Preparation - ENGLISH
• Informatica Interview ...
🔵 Informatica Interview Preparation - TAMIL
• Informatica Interview ...
*******************************************************************************
🌕 For Training contact/Whatsapp:
[phone]
********************************************************************************
🌕 Informatica Interview Preparation - Live session 2
• Informatica Interview ...
🔵 Informatica Interview Preparation - Live session 1
• Informatica Interview ...
🌕 Informatica interview preparation | Informatica interview questions scenario based
• Informatica interview ...
🔵 How to explain Informatica ETL project in interview தமிழில் | Informatica Project Architecture
• How to explain Informa...
*********************************************************************************
In this video, we’ll learn Expression transformation in Informatica,
expression transformation in informatica,
expression transformation,
informatica,informatica basics,
informatica tutorials,
informatica power center,
questions,interview,
data ware house
informatica interview preparation,informatica interview questions,informatica interview scenarios,informatica interview videos,informatica interview,informatica admin interview questions,informatica powercenter interview questions,informatica interview questions and answers,informatica training,informatica powercenter,informatica tutorial,informatica tutorial in tamil,informatica,#informaticatutorial#,informatica tutorial for beginners
informatica interview preparation,informatica interview scenarios,informatica interview questions,informatica interview videos,informatica interview,informatica admin interview questions,informatica interview tips,informatica interview questions and answers,informatica powercenter interview questions,technical interview questions,informatica questions,informatica training,informatica answers,informatica powercenter,informatica tutorial
====================================================
Audio track credit:
Believe Music

[@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 ======================================================================= 🔵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

[@aofh666]

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.

[@NICITACADEMY]

You are welcome!

[@kainatxkay]

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.

[@NICITACADEMY]

You're very welcome!

[@kotamyogeswarreddy5165]

Very Cristal clear explanation sir,tq so much

[@NICITACADEMY]

You are welcome

[@TusharMUNESHWAR-v4i]

Very Useful, Nice Explanation 🙌

[@NICITACADEMY]

Thank you for watching!

[@manishapanchal1915]

Thank you so much sir for explain everything in detail. God bless you sir.

[@NICITACADEMY]

You are most welcome

[@santhoshimurugan8160]

Such a detailed video.... great explanation sir...

[@NICITACADEMY]

Thank you. Keep watching my channel.

[@vaibhavivm2541]

how to increase font size the way u did at 20:36 , not working ctrlA AND ctrl+, or is it different for different version

[@ankushchinchane9258]

Very good explanation and really appreciate your efforts sir

[@NICITACADEMY]

Thanks and welcome

[@neeharikar9203]

Thnq so much for your detailed explanation on each topic sir ..how can I get data for doing exercises??

[@venugopalreddy5411]

Very useful information for learners..

[@NICITACADEMY]

Thanks a lot

[@erigelavani4162]

Thanks for video 😊

[@NICITACADEMY]

Welcome 😊

[@kavithapitchiah1832]

Very nice explanation Thanks.. Expression Transformation notes not available in the description, Kindly provide for practice

[@NICITACADEMY]

I will update

[@aaseembaigmirza4486]

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

[@PradeepKanaparthy]

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?

[@IronMan_2.1]

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 ?

[@NICITACADEMY]

You can use LPAD or regular expression replace for complex logic

[@babanewswale8859]

Big big thnks to u....

[@NICITACADEMY]

Most welcome

[@aarchana1810]

Hello sir pls tell me which transformation is used to enter names in name column

[@NICITACADEMY]

Expression Transformation

[@aarchana1810]

@@NICITACADEMY Thank you sir

[@naliniswaraj4984]

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.

[@NICITACADEMY]

Hi Sure, Kindly keep watching my channel, I will add in English ASAP. Please refer to your friends. Thanks for your comments and feedback.

[@mukulsingh5634]

Please provide link sQL single row function link

[@NICITACADEMY]

kzbin.info/www/bejne/aqKte6uHqq1_eZY

[@palusammunisathish7872]

From where we can get the example data which u are used in the videos

[@NICITACADEMY]

Please watch my installation video

[@pramodgadekar3081]

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 👌

[@NICITACADEMY]

please contact me for more details. [e-mail]

[@sumanshrestha3051]

sir how to open the notes and exercise that you have provided in the link and thank you for the video.

[@NICITACADEMY]

Please Check description

[@dadanoor1088]

Hi sir , can you please provide link for SQL single row function video

[@NICITACADEMY]

I have already posted, please check the playlist.

[@susmitajha472]

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?

[@NICITACADEMY]

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. kzbin.info/www/bejne/pITWZnZmeJaWbJY

[@susmitajha472]

Thank you💕

[@susmitajha472]

@@NICITACADEMY can we use filter transformation for this question?

[@NICITACADEMY]

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,

[@susmitajha472]

Yes sure, Thanks. 💕

[@kaveribhar8197]

Please create video on following topics : a. Cleaning the data b. Reusability features c. Command line utilities d CDC and constraint based learning

[@NICITACADEMY]

Sure.

[@prabha-cn3xx]

hi, I couldn't find the exercises? please help

[@NICITACADEMY]

Please get complete material from here courses.nicitacademy.com/

[@lakshmimahi3209]

Hi sir, Please post the informatica interview questions and answers in one video

[@NICITACADEMY]

Ok sure

[@trueorfalse3999]

How to solve the Sum(salary) for all target table instead of salary

[@NICITACADEMY]

Please watch Aggregate functions in SQL: (To understand better) kzbin.info/www/bejne/qYa4Yayan9h9r6M

[@swathithodeti9810]

Sir , please upload all videos, in scd

[@NICITACADEMY]

Okay sure.

[@Cheybanala]

any update on missing videos 6,7,8 and 9

[@NICITACADEMY]

Thanks, it will be uploaded

[@Cheybanala]

Can I get the link for those videos Sir I'm unable to find in KZbin

[@govindkota1026]

There are so many videos in Tamil. Please add English subtitles. We can understand it.

[@NICITACADEMY]

I have already posted same videos in English please check the playlist

[@saivenkat9681]

Sir expression notes not open , they asking password sir

[@NICITACADEMY]

please check the description for password

[@sujithakarnati]

Single row functions link please

[@NICITACADEMY]

Please check the below English: kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF Tamil: kzbin.info/aero/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4

[@mukulsingh5634]

@nicitacademy

[@NICITACADEMY]

kzbin.info/www/bejne/aqKte6uHqq1_eZY