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
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
th-cam.com/video/C1zGVRFM3-A/w-d-xo.html
📌*Informatica Full Course:*
th-cam.com/video/V2FtZ_INmjg/w-d-xo.html
📌*SQL Full Course:*
th-cam.com/video/iuvzjf7nU1I/w-d-xo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
th-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
th-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
th-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
th-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
th-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
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.

[@DeibyAvila]

Thanks, Excelent material!

[@NICITACADEMY]

Much appreciated!

[@meiyetina]

Job well done

[@kotamyogeswarreddy5165]

Very useful sir.Tq so much 🙏🙏🙏

[@NICITACADEMY]

Thanks

[@Ss_Ai_Infa_Tech]

Excellent explanation 👌

[@NICITACADEMY]

Thank you 🙂

[@saritapradhan5851]

This video is very helpful

[@NICITACADEMY]

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

[@sivakumaresakki4463]

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

[@NICITACADEMY]

Yes, soon I will upload.

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

[@SANDEEPkumar-ui7el]

VERY HELPFULL VIDEO

[@NICITACADEMY]

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

[@VenkateswarluGummadi-ob8xq]

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

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

[@electricpants5624]

You just earned a like and subscriber! Superb explanation

[@NICITACADEMY]

Thanks. Keep watching

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

[@almassteachingworld0109]

Amazing 👍

[@NICITACADEMY]

Thanks 😄

[@joshuasathracmoses]

Sir what is diff between partition and concurrent workflow

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

[@nikhilchavan8890]

Please create videos on API....

[@NICITACADEMY]

Sure, I will post. Keep watching my channel.

[@abhijitnandy2401]

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

[@NICITACADEMY]

please join my live training sessions

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

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

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