Expression Transformation in Informatica | Informatica tutorial for beginners

Поделиться
HTML-код
  • Опубликовано: 7 ноя 2024

Комментарии • 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
    ruclips.net/p/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF
    📌*IICS demo session:*
    ruclips.net/video/C1zGVRFM3-A/видео.html
    📌*Informatica Full Course:*
    ruclips.net/video/V2FtZ_INmjg/видео.html
    📌*SQL Full Course:*
    ruclips.net/video/iuvzjf7nU1I/видео.html
    📌*Informatica, IICS, and SQL playlist*
    🌕 IICS Tutorial ENGLISH - Playlist
    ruclips.net/p/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj
    🌕 Informatica training in ENGLISH - Playlist
    ruclips.net/p/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd
    🌕 Informatica Interview Preparation - ENGLISH
    ruclips.net/p/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d
    🌕Oracle SQL - தமிழில்
    ruclips.net/p/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4
    🔵 Informatica training in தமிழில் - Playlist
    ruclips.net/p/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3
    🔵 Informatica Interview Preparation - TAMIL
    ruclips.net/p/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD
    🔵Unix for Informatica Developer
    ruclips.net/p/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw
    🌕Informatica Project videos
    ruclips.net/p/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6
    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 9 месяцев назад +1

    Very useful information for learners..

  • @ankushchinchane9258
    @ankushchinchane9258 2 года назад +1

    Very good explanation and really appreciate your efforts sir

  • @PradeepKanaparthy
    @PradeepKanaparthy 8 месяцев назад

    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?

  • @santhoshimurugan8160
    @santhoshimurugan8160 2 года назад +1

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

    • @NICITACADEMY
      @NICITACADEMY  2 года назад +1

      Thank you. Keep watching my channel.

  • @kavithapitchiah1832
    @kavithapitchiah1832 Год назад +1

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

  • @erigelavani4162
    @erigelavani4162 Год назад +2

    Thanks for video 😊

  • @aaseembaigmirza4486
    @aaseembaigmirza4486 8 месяцев назад

    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

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

  • @aarchana1810
    @aarchana1810 2 года назад +2

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

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

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

  • @babanewswale8859
    @babanewswale8859 2 года назад +1

    Big big thnks to u....

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

  • @mukulsingh5634
    @mukulsingh5634 7 месяцев назад +2

    Please provide link sQL single row function link

    • @NICITACADEMY
      @NICITACADEMY  7 месяцев назад

      ruclips.net/video/4qJJxQuHLC4/видео.html

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

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

  • @lakshmimahi3209
    @lakshmimahi3209 2 года назад +1

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

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

  • @prabha-cn3xx
    @prabha-cn3xx 9 месяцев назад +1

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

    • @NICITACADEMY
      @NICITACADEMY  9 месяцев назад

      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.

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

  • @swathithodeti9810
    @swathithodeti9810 2 года назад +1

    Sir , please upload all videos, in scd

  • @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)
      ruclips.net/video/sUU0ydjsJyA/видео.html

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

  • @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.
      ruclips.net/video/nSs5C0C1c64/видео.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. 💕

  • @sujithakarnati
    @sujithakarnati 2 года назад +1

    Single row functions link please

    • @NICITACADEMY
      @NICITACADEMY  2 года назад

      Please check the below
      English: ruclips.net/p/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF
      Tamil: ruclips.net/p/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4

  • @saivenkat9681
    @saivenkat9681 2 года назад +1

    Sir expression notes not open , they asking password sir

    • @NICITACADEMY
      @NICITACADEMY  2 года назад

      please check the description for password

  • @mukulsingh5634
    @mukulsingh5634 7 месяцев назад +1

    @nicitacademy

    • @NICITACADEMY
      @NICITACADEMY  7 месяцев назад

      ruclips.net/video/4qJJxQuHLC4/видео.html