Router Transformation in Informatica

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

[@srinuvasan2050]

Now I wonder router transformation is this much easy....thank you so much

[@NICITACADEMY]

You are welcome

[@18.manojkumar33]

Sir, why we are keeping target load type as bulk

[@srinuvasan2050]

Please guide me to load the input data in reverse order by using expression. 🙏

[@NICITACADEMY]

Hi Srinuvasan, You have to use variable port to generate sequence in expression transformation, then sorter transformation to reverse(descending)

[@srinuvasan2050]

@@NICITACADEMY thank you sir

[@sivanewinterjourny4844]

Hi ji.. can you please make a video one of complex scenario you were worked.

[@NICITACADEMY]

yeah sure. Keep watching my channel. I will post ASAP.

[@meetmrbrucekadin-dogoargen2655]

Sir do u take any classes for greenplum database

[@NICITACADEMY]

Hi Sneha, No. I am handling Oracle PLSQL, Informatica PowerCenter, Power BI, Tableau and Big data.

[@meetmrbrucekadin-dogoargen2655]

@@NICITACADEMY thanks for letting me know if you can help me some right person to learn greenplum database that will be useful

[@meetmrbrucekadin-dogoargen2655]

And also wishing to know whether u take regular classes ?

[@NICITACADEMY]

Yes, You can get the contact in the about channel section.

[@narmadajha3860]

Sir please help me in how to first half record in 1 tgt and another half in 2nd. Which all transformation we have to use other than expression..

[@NICITACADEMY]

Okay, I will post a video. we have to use Aggregator to count and take half.

[@umagaddam5983]

Tq sir, clear explanation

[@NICITACADEMY]

Thank you

[@Cheybanala]

router not connected with targets what might the issue

[@NaveenKumar-xs3no]

Nice bro well explained

[@NICITACADEMY]

Thanks

[@srinivasn9613]

Hi Sir, thank you for the beautiful video. I assume that you've used "alter--add column name" to add column 'COUNTRY'. How did you add country names to 107 records. Could you help me with this.

[@NICITACADEMY]

Yes, correct. I have added a column and manually updated the value by copy and paste. in SQL developer go to tables and manually update.

[@srinivasn9613]

Subscribed!

[@NaveenKumar-xs3no]

Bro can you please help me to find the maximum date has minimum I'd in teradata

[@NICITACADEMY]

Use rank or max() function.

[@NaveenKumar-xs3no]

@@NICITACADEMY thanks bro

[@Cheybanala]

sir please upload 6,7,9 and 10 sessions

[@pratikhande5263]

Sir, how to find employees with a hire date of leap year in one target and employees with a hire date of the nonleap year in another target in router transformation. Please help me.

[@NICITACADEMY]

Group 1: MOD(get_date_part(hire-date,'yyyy'),4)=0 Group 2: MOD(get_date_part(hire-date,'yyyy'),4)!=0

[@pratikhande5263]

@@NICITACADEMY Thank you so much Sir. 👍👍

[@geetadhakal4649]

Can you please upload sessions 6,7,9 and 10🙏🙏

[@NICITACADEMY]

Sure, I will upload one by one.

[@InformaticaLovers]

Hi Sir, If we have a record satisfying more than 1 groups conditions then in which group it will fall?

[@NICITACADEMY]

It will flow in all the groups where the condition is stratified

[@santhoshimurugan8160]

Sir can you teach about connection transformation

[@NICITACADEMY]

Hi.. we do not have any transformation named as connection. did you mean custom transformation?

[@santhoshimurugan8160]

@@NICITACADEMY u mentioned like active , connection...so what does connected means sir?

[@NICITACADEMY]

Please watch this below video for transformation types and connected, not connected transformation. Please watch informatica playlist. You will get all the concepts. kzbin.info/www/bejne/d3jCaod4hK6doq8

[@santhoshimurugan8160]

@@NICITACADEMY thankyou sir

[@santhanakumar9451]

Sir, when i import a target table, "date" column datatype as "date" in SQL server is imported as "Date/time" in Informatica. How can I fix this issue.

[@NICITACADEMY]

That is not an issue. Informatica will decode.

[@santhanakumar9451]

@@NICITACADEMY Thanks sir. Your videos are very helpful, I am working in a proj with Informatica and I am getting all the basic essentials from your videos. You are doing a great social knowledge transfer service.

[@yourssnsk7260]

Sir I need created tables for practice, pls help me

[@NICITACADEMY]

Please install Oracle 11g. kzbin.info/www/bejne/gKPIl55nnbR9h8k

[@haciomergumusbas]

Hello, First of all, thank you very much for your videos that are very helpful for me but but I have a hard time because some videos don't have subtitles. Can you add subtitles for all videos? If you can I would appreciate. Thanks again, have a good day.

[@NICITACADEMY]

I have uploaded all the transformation with Informatica 10 hours video. Please watch this kzbin.info/www/bejne/eYq4eqeZrtCAiqs

[@haciomergumusbas]

@@NICITACADEMY thank you 🙏🙏🙏

[@sekhar5430]

Thank you sir

[@NICITACADEMY]

Welcome

[@NICITACADEMY]

Welcome

[@aakashb5266]

Hi Sir, could you please do videos on http transformation windows based informatica / WSDL concept Thanks in Advance!

[@NICITACADEMY]

Noted. I am working on it