The explanation is just awesommmmmmme..... Good job Man!!!
@KalyanS3 жыл бұрын
Nice Explanation on SQL Transformation
@AlokMauryaCSEengineer5 жыл бұрын
Very nice explaination ...👍
@karunkrishna18832 жыл бұрын
Hi Saif, Can you create a video on pending transformation. Please cover all the transformations and scenario-based Interview questions.
@sahmed40704 жыл бұрын
Thanks a lot Saif!
@nikitakorde47162 жыл бұрын
Thanks, this was helpful
@ravishankar09017 жыл бұрын
Thanks saif for wonderful explanation . Ravi Shankar - Pune
@BalaMurugan106 жыл бұрын
Thanks Saif! useful one
@nagurmeeravalisk98345 жыл бұрын
superb.. can you enable dynamic and explain some scenario plz?.
@vikrantmukkawar97373 жыл бұрын
Please explain about static and dynamic connection here and static and dynamic query
@mohadinthu4 жыл бұрын
Hi Saif nice explaination along with the examples. I have a doubt while u r using script mode in SQL Transformation u have given the source as file names and it's appropriate paths.But this type of loading is called indirect loading rite.but I can see u haven't enabled type of load as indirect in session level.Can u please explain
@punamrathod57136 жыл бұрын
Hi Saif could you please upload the mappings related to pattern program...
@charming69533 жыл бұрын
Hi Saif, I have a question when it is generally asked in ETL interview to explain about the types of transformations, which transformations we should explain? And also, if we are answering it as Active and Passive, do I need to explain their types further?
@saifshaikh71893 жыл бұрын
Yes. Try to explain transformations such as expression, joiner, lkp, agg, filter, router, mapplets etc. Also while explaining in interview try to relate an ex of thiese trasformations from your current project shown on CV so that it will relate what you are saying and what's on your CV.
@dalowarhossain77724 жыл бұрын
Is there any port named NumRowsAffected, in sql transformation? If yes how can I find that?
@ur89467 жыл бұрын
H Saif , I have one question on SQL transformation in script mode. there two script one create table i.e. DDL second one is DML First time mapping run sucssess fully it will create the table and insert the records. but when we run the same mapping second time ideally it should failed but session run successfully, when I see session log it is showing error object already exist. My question is why session didn't failed , Please reply me
@saifshaikh71897 жыл бұрын
Hi, The reason the session din't failed bcoz we have not added error handling properties at session level. If you go to session properties, there is one property which says Stop on Error assign a value of 1 in place of 0 which means as soon as the 1st bad record comes the session will fail.
@ur89467 жыл бұрын
thanks for reply
@BuntyMix174 жыл бұрын
@@saifshaikh7189 Can we pass multiple SQL statements in one script? Please reply
@shamimshaikh5064 жыл бұрын
@@BuntyMix17 yes in script mode.
@BuntyMix174 жыл бұрын
@@shamimshaikh506 ty
@franciso46505 жыл бұрын
How can you be contacted?
@fishsauce74976 жыл бұрын
Bhai your videos are very nice and informative, but the tone is not beautiful or appropriate :p itna attitude??