why lookup is an active transformation lookup policy on multiple match

#Informatica#informaticatutorial#informaticapowercenter#informaticatransformations
In this session we will learn about informatica interview preparation,informatica interview scenarios,informatica interview questions,informatica interview questions and answers,lookup transformation in informatica,lookup trsnsformation,lookup in informatica,informatica lookup transformation,lookup policy on multiple matches,why lookup is an active transformation,why lookup is active transformation in informatica,Lookup Transformation is Active,Lookup : Active or Passive And why,Handling Multiple Matches,Lookup Policy on Multiple Match in Informatica,Lookup Policy On Multiple Match
=======================================================
🌕 Want to join my Informatica upcoming online batches?
Please join in the WhatsApp group for an update
chat.whatsapp....
🔵 It is Job based - Live online training session
🔵 100% Job assistance, Real time training.
🔵 Resume preparation, Interview preparation supported.
🔵 Project explanation, Mock interviews will be taken.
1. Interview preparation, mock interview taken
2. Low cost training
3. Job Assistance
4. Mentors with 14+ yrs
5. Job Oriented Training
6. Life time video recording access
Informatica Demo session link:
🔵English: • Informatica demo sessi...
• Informatica Demo sessi...
🔵Tamil: • Informatica Tutorial d...
IICS Training - Demo session:
🔵English: • IICS demo | iics tutor...
📌For more details on Timing, Fees, Course Content contact me on WhatsApp
🌕wa.link/m4lat0
(📢📢Trainer: Chandra - A Tableau and Informatica certified Professional)
📌Having 14+ years of IT experience in Banking, Insurance and Retail domain
📌Trained 1000+ students in last 7 years
📌Handled corporate and Live training sessions
Thanks for watching and supporting me. 🤝
Kindly subscribe to the channel for more updates.
Please like 👍 and share my videos with your friends, It will encourage you to post more videos.
Please add comments if you have any queries. I will respond to your queries.
Please suggest any video topics or any new topics in the comments section. I will post more videos on that topics
Keep watching my channel. 🙂
========================================================
🌕Want to join WhatsApp Group? (Only technical discussion, no spam messages, no promotion msg)
🔵Informatica PowerCenter
github.com/nic...
🔵Oracle-SQL
github.com/nic...
🔵IICS
github.com/nic...
🌕 Informatica 10.4 Installation with steps:
• Informatica Installati...
*********************************************************************
🔵 Informatica PowerCenter Whatsapp Group for Updates/Doubts/Interview /Discussion
chat.whatsapp....
**********************************************************************
🔵Informatica training in TAMIL - Playlist
• Informatica Training -...
🌕 Informatica training in ENGLISH - Playlist
• Informatica Training S...
🔵Informatica Interview Preparation - TAMIL
• Informatica Interview ...
🌕 Informatica Interview Preparation - ENGLISH
• Informatica Interview ...
****************************************************************************
informatica training in tamil,informatica in tamil,informatica tutorial in tamil,informatica interview tips in tamil,informatica tutorial for beginners in tamil,informatica interview preparation in tamil,informatica online tutorial tamil,informatica transformations with examples,informatica powercenter training,informatica tutorial,informatica,informatica tutorial for beginners,informatica - router transformation,flatfile to table load in tamil
informatica interview preparation in tamil,informatica interview preparation,informatica interview tips in tamil,informatica interview questions,informatica interview experience,informatica project explanation in tamil,informatica training in tamil,informatica interview questions scenario based,informatica training online free in tamil,informatica tutorial in tamil,informatica tamil,informatica production support issues,#informaticatutorial#
lookup transformation in informatica,lookup trsnsformation,lookup in informatica,informatica lookup transformation,informatica transformation,learn informatica powercenter,informatica classes,lookup cache concept,informatica tutorials,lookup cache,informatica etl training,informatica online course,informatica video training,informatica tutorial videos,informatica online tutorial,lookup policy on multiple matches
====================================================
Audio track credit:
Believe Music

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

[@soumyaranjanpanigrahi2813]

Sir please make a video on when to use static dynamic and persistent cache with relevent examples...and XML transformation and when to use

[@NICITACADEMY]

As soon as possible. Keep watching my channel.

[@bnlamiya]

I understand the fact there are 2 different active transformations so we are using joiner before passing the data to Target, can we also use UNION and then filter or sort records?

[@jeyaprakash2463]

What is about lookup override?

[@a2zgyan3417]

unconnected lookup is active or passive transformation? and why

[@kshpriya9917]

Hi sir ...your vedios are really helpful Thanks a lot for that...please do vedio on static lookup and dynamic lookup along cache files in lookup .

[@NICITACADEMY]

Sure I will

[@sooraj5370]

sir do a video on ETL testing, DWH, SQL important interview Qs

[@NICITACADEMY]

I have already posted in our channel. Kindly check playlist.

[@akashnanaware6427]

Thank you so much

[@NICITACADEMY]

You're most welcome

[@rajachinna9954]

Hi sir, Can we use source qualifier after lookup instead of sorter transformation?

[@NICITACADEMY]

NO, not possible

[@jangamlaxmangoud6194]

Sir please make a video on data validation by taking sample records

[@NICITACADEMY]

Okay sure, Keep watching my channel.

[@sooraj5370]

do a video on different data validation methods sir

[@NICITACADEMY]

Will do soon

[@shristimohanty2876]

How is department id null in target table (result) if master outer join is present

[@shristimohanty2876]

Is than means detail table had a null department id

[@srinuvasan2050]

Please do a video on unit testing

[@NICITACADEMY]

Sure Srini.. Thanks. Will do soon.

[@sharathreddy159]

@@NICITACADEMY yes sir we need UT video please

[@sindhuja7538]

Sir can’t understand Cartesian product

[@NICITACADEMY]

Cartesian product means each record will get join with other records. Please watch my SQL Join session. I have explained.

[@sindhuja7538]

Ok sir thankyou

[@sreeramm9470]

hello sir, can u write a query using SQL increament 10% salary for 10th department employees, 20% salary increament for 20th department emplyees and 5% salary for remaining departments emplyees from employees table please write a general query thank u very much.

[@NICITACADEMY]

Please use case statement in SQL, Expression transformation in Informatica.

[@sreeramm9470]

@@NICITACADEMY i am just beginer dont know how to phrase case statement.

[@sreeramm9470]

@@NICITACADEMY please write a query sir. thanks

[@Venki_Talks]

Lookup transformation is passive transformation but your are saying active transformation

[@NICITACADEMY]

Lookup is an active transformation.

[@naliniswaraj4984]

Request you to post video on Xml transformation

[@NICITACADEMY]

As soon as possible I will upload. Keep watching my channel.

[@amruthajagga3076]

Is anyone NIC it academy frnds.. I need informatics persons