Session # 12 - Aggregator Transformation in Informatica | Informatica Training for Biginners

Поділитися
Вставка
  • Опубліковано 7 лис 2024

КОМЕНТАРІ • 31

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

    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

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

    I hvae seen many videos' but finally I watched NIC IT and clear the all concepts Thanks

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

      Thanks for your valuable feedback. Keep watching my channel 😊

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

    one of the best channel for Informatica concepts ... thanks sir ...

  • @JyothiAnandan-t9y
    @JyothiAnandan-t9y Рік тому +2

    Very very informative and explanation is very logical and relatable Sir.

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

    Thanks for this beautiful session on Aggregator transformation..

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

    I think in index cache, group by condition would hold instead of sorter condition. Anyways it's same as sorter condition is on group by field

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

    How to convert by using decode function in informatica power enter 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

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

    HI sir,can u pls explain that assignment question also

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

      Please watch my Oracle Aggregate functions for more details.
      ua-cam.com/video/BSiCWzj-py8/v-deo.html

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

    Thank you for making this, it was quite informative !!

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

    it was good explaination sir tq

  • @VigneshKumar-s9h
    @VigneshKumar-s9h Рік тому

    I have two fields amount and sum_amount defined as 16,4 decimal in my aggregator. My input has amount as 1000.2525 & 1000.2050. My expected sum_amount is 2000.4575, but my aggregator is producing result as 2000.4600. It is rounding off for 2 decimals even though I didn't provide any round off function. Could you please help me out here

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

    Super sir...

  • @ItsComplicated58
    @ItsComplicated58 Рік тому

    Best video

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

    Sir please share single row function vedio link in english
    Iam not getting

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

      ua-cam.com/video/hLnKjYGr730/v-deo.html

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

    pm parse error

  • @teja2775
    @teja2775 3 роки тому +1

    Hello sir, How you are selecting multiples names at a same time in transformation table like from Employee id to Job id you selected at a same time can you gives us that tip....

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

      Use shift + and the port select

    • @teja2775
      @teja2775 3 роки тому

      @@NICITACADEMY Thankyou sir

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

    sir,after aggregator transfermation am doing filter transfermation in that transfermation o_sum_salary wiil not validate like o_sum_salary>50000
    the expression is not valid

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

      Hi, You can use filter, Please check the syntax and data type.

    • @vamsidharreddy8036
      @vamsidharreddy8036 Рік тому

      we can given the expression field sum_Salaray>50000

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

    Hi