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

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

[@pravinshinde1891]

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

[@NICITACADEMY]

Thanks for your valuable feedback. Keep watching my channel 😊

[@saiprasadsavarkar2075]

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

[@NICITACADEMY]

Thanks a ton

[@JyothiAnandan-t9y]

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

[@NICITACADEMY]

Thanks for liking

[@shaiktabrezahmed209]

Thanks for this beautiful session on Aggregator transformation..

[@NICITACADEMY]

Always welcome

[@sushmakudipudi2684]

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

[@Viqram1]

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

[@vyshnavib8023]

HI sir,can u pls explain that assignment question also

[@NICITACADEMY]

Please watch my Oracle Aggregate functions for more details. kzbin.info/www/bejne/eITMdIqwn5Kjr5o

[@aaseembaigmirza4486]

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

[@praneetnema7592]

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

[@NICITACADEMY]

kzbin.info/www/bejne/nn3RfJ2PfNdqaZI

[@mohammadrc]

it was good explaination sir tq

[@NICITACADEMY]

Thank You

[@ItsComplicated58]

Best video

[@NICITACADEMY]

Thanks, Keep watching my channel.

[@vamshikrishnagadde7852]

pm parse error

[@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]

Super sir...

[@NICITACADEMY]

Thanks

[@teja2775]

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]

Use shift + and the port select

[@teja2775]

@@NICITACADEMY Thankyou sir

[@vamshikrishnagadde7852]

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]

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

[@vamsidharreddy8036]

we can given the expression field sum_Salaray>50000

[@kunchamusharani7311]

Hi