Expression Transformation in Informatica | Informatica tutorial for beginners

Поділитися
Вставка
  • Опубліковано 19 жов 2024
  • #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 nicitacademy@gmail.com/ 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 nicitacademy@gmail.com/ 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:
    +91 7010080468
    ********************************************************************************
    🌕 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

КОМЕНТАРІ • 69

  • @NICITACADEMY
    @NICITACADEMY  2 роки тому +2

    *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

  • @aofh666
    @aofh666 Рік тому +2

    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.

  • @kainatxkay
    @kainatxkay Рік тому +1

    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.

  • @kotamyogeswarreddy5165
    @kotamyogeswarreddy5165 2 роки тому +2

    Very Cristal clear explanation sir,tq so much

  • @manishapanchal1915
    @manishapanchal1915 Рік тому +1

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

  • @neeharikar9203
    @neeharikar9203 Рік тому +1

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

  • @venugopalreddy5411
    @venugopalreddy5411 8 місяців тому +1

    Very useful information for learners..

  • @ankushchinchane9258
    @ankushchinchane9258 2 роки тому +1

    Very good explanation and really appreciate your efforts sir

  • @santhoshimurugan8160
    @santhoshimurugan8160 2 роки тому +1

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

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому +1

      Thank you. Keep watching my channel.

  • @PradeepKanaparthy
    @PradeepKanaparthy 7 місяців тому

    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?

  • @erigelavani4162
    @erigelavani4162 Рік тому +2

    Thanks for video 😊

  • @mukulsingh5634
    @mukulsingh5634 6 місяців тому +2

    Please provide link sQL single row function link

    • @NICITACADEMY
      @NICITACADEMY  6 місяців тому

      ua-cam.com/video/4qJJxQuHLC4/v-deo.html

  • @vaibhavivm2541
    @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

  • @kavithapitchiah1832
    @kavithapitchiah1832 Рік тому +1

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

  • @babanewswale8859
    @babanewswale8859 2 роки тому +1

    Big big thnks to u....

  • @aaseembaigmirza4486
    @aaseembaigmirza4486 7 місяців тому

    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

  • @IronMan_2.1
    @IronMan_2.1 Рік тому +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
      @NICITACADEMY  Рік тому

      You can use LPAD or regular expression replace for complex logic

  • @naliniswaraj4984
    @naliniswaraj4984 2 роки тому +3

    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
      @NICITACADEMY  2 роки тому +3

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

  • @aarchana1810
    @aarchana1810 2 роки тому +2

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

  • @pramodgadekar3081
    @pramodgadekar3081 Рік тому +2

    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
      @NICITACADEMY  Рік тому

      please contact me for more details.
      nicitacademy@gmail.com

  • @palusammunisathish7872
    @palusammunisathish7872 2 роки тому +1

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

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      Please watch my installation video

  • @kaveribhar8197
    @kaveribhar8197 2 роки тому +1

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

  • @prabha-cn3xx
    @prabha-cn3xx 8 місяців тому +1

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

    • @NICITACADEMY
      @NICITACADEMY  8 місяців тому

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

  • @sumanshrestha3051
    @sumanshrestha3051 2 роки тому +1

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

  • @lakshmimahi3209
    @lakshmimahi3209 2 роки тому +1

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

  • @dadanoor1088
    @dadanoor1088 2 роки тому +1

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

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      I have already posted, please check the playlist.

  • @trueorfalse3999
    @trueorfalse3999 2 роки тому +1

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

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      Please watch Aggregate functions in SQL: (To understand better)
      ua-cam.com/video/sUU0ydjsJyA/v-deo.html

  • @susmitajha472
    @susmitajha472 2 роки тому +1

    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
      @NICITACADEMY  2 роки тому +1

      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

    • @susmitajha472
      @susmitajha472 2 роки тому +1

      Thank you💕

    • @susmitajha472
      @susmitajha472 2 роки тому +1

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

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому +1

      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
      @susmitajha472 2 роки тому

      Yes sure, Thanks. 💕

  • @swathithodeti9810
    @swathithodeti9810 2 роки тому +1

    Sir , please upload all videos, in scd

  • @govindkota1026
    @govindkota1026 2 роки тому +1

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

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

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

  • @saivenkat9681
    @saivenkat9681 2 роки тому +1

    Sir expression notes not open , they asking password sir

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      please check the description for password

  • @Cheybanala
    @Cheybanala 2 роки тому +1

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

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому +1

      Thanks, it will be uploaded

    • @Cheybanala
      @Cheybanala 2 роки тому

      Can I get the link for those videos Sir I'm unable to find in UA-cam

  • @sujithakarnati
    @sujithakarnati 2 роки тому +1

    Single row functions link please

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      Please check the below
      English: ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
      Tamil: ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html

  • @mukulsingh5634
    @mukulsingh5634 6 місяців тому +1

    @nicitacademy

    • @NICITACADEMY
      @NICITACADEMY  6 місяців тому

      ua-cam.com/video/4qJJxQuHLC4/v-deo.html