Performance Tuning, Push down optimization and Partitioning 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

[@BanglaBloke]

Do you have IICS Interview question dumps?

[@MrDeadly23]

Awesome describing about the Performance tuning, Pushdown Optimization and Partitioning.

[@NICITACADEMY]

Thank You, Keep watching my channel.

[@srinivasvemula2331]

great explaining from you. covered advanced topics for realtime interview😃

[@NICITACADEMY]

Glad it was helpful!

[@vamshidharv7]

Excellent explanation !! Very useful one. Thank you Chandra for sharing the videos. Keep uploading more such videos.

[@NICITACADEMY]

Thank you so much 🙂 Keep watching my channel.

[@Ss_Ai_Infa_Tech]

Excellent explanation 👌

[@NICITACADEMY]

Thank you 🙂

[@meiyetina]

Job well done

[@DeibyAvila]

Thanks, Excelent material!

[@NICITACADEMY]

Much appreciated!

[@kotamyogeswarreddy5165]

Very useful sir.Tq so much 🙏🙏🙏

[@NICITACADEMY]

Thanks

[@ashishkumarwankhede9692]

Thank you very much so much clear- and simple way you have explain. Can you able to make video same for IICS?

[@NICITACADEMY]

Yes, sure

[@saritapradhan5851]

This video is very helpful

[@NICITACADEMY]

Thank you, you are most welcome. Keep watching my channel.

[@almassteachingworld0109]

Amazing 👍

[@NICITACADEMY]

Thanks 😄

[@VenkateswarluGummadi-ob8xq]

Which partion is better ?? And why it is better pass through partion and range partion??

[@srishti.shetty]

Amazing explaination! One doubt u mentioned in the end 'busy percantage and bottleneck' what is that how to identify that?

[@NICITACADEMY]

we have to check the session log.

[@SK-kg6en]

at 0.24secs, when those transformations create performance issues and should not prefer, when to use them then? Is it when the data volume is less?

[@electricpants5624]

You just earned a like and subscriber! Superb explanation

[@NICITACADEMY]

Thanks. Keep watching

[@SANDEEPkumar-ui7el]

VERY HELPFULL VIDEO

[@NICITACADEMY]

Thanks for your valuable feedback, keep watching. Refer to your friends.

[@sivakumaresakki4463]

very needfull topic dear thanks for this video, Can you please post Index topic.

[@NICITACADEMY]

Yes, soon I will upload.

[@sowjanyaprathi8968]

Excellent explanation.. Can you please explain recovery management also in information and when any session got failed after loading some data how to run the session to load the data from there onwards instead from starting

[@NICITACADEMY]

Sure, Definitely. This can be achieved by different ways 1) Dynamic lookup cache 2) Recovery strategy 3) CDC concepts by set_max variables etc I will make one video on this topic. Keep watching my channel.

[@RashmithaChinthanippula]

Can we use pass through partition when we are deleting huge amounts of data using an update strategy

[@nikhilchavan8890]

Please create videos on API....

[@NICITACADEMY]

Sure, I will post. Keep watching my channel.

[@joshuasathracmoses]

Sir what is diff between partition and concurrent workflow

[@abhijitnandy2401]

Hi Is there any videos on Dynamic Mapping and Elastic mapping ?

[@NICITACADEMY]

please join my live training sessions

[@soumyaranjanpanigrahi2813]

Sir please upload XML transformation, all caches in lookup transformation with details examples and the possible interview questions for informatica

[@NICITACADEMY]

As soon as possible. Keep watching.

[@joshuasathracmoses]

if we have flatfile as source is it possible to do partition

[@NICITACADEMY]

No

[@babloochowdary7642]

MY partiton options is disabled in session mapping , how to make it enable ,please help me.yesterday i have paid for level II.

[@NICITACADEMY]

Upgrade to 10.4 or 10.2 version

[@KALIMABEEVI-b7i]

SIR WHEN I WRITE OPB_SUBJECT IN ADMIN SCHEMA IT SHOWS LIKE TABLE OR VIEW DOES NOT EXIST

[@neethisurya9755]

How to validate meta data validation?? Metadata queries?

[@NICITACADEMY]

run the meta data queries in Repository database and validate.

[@lohithna3053]

Hi sir do u have full informatica paid tutorials?

[@NICITACADEMY]

Please send me mail [e-mail] or ping me @7010080468

[@joshuasathracmoses]

sir i dint understand how 100/3 will come as 1

[@NICITACADEMY]

It is modulus function, it will return reminder.

[@bipinparajuli9126]

Is parallel processing and round robin same

[@NICITACADEMY]

No

[@tymalone1937]

💪 P"R"O"M"O"S"M!!!

[@SNUNITED-zt5cf]

Excellent explanation 👌

[@NICITACADEMY]

Thanks 🙏