SQL Transformation Query Mode in Informatica cloud| IICS | IDMC

A SQL Transformation can be used to process a SQL query either using a “Saved Query” or a User “Entered Query”. The SQL transformation can return multiple output rows of the configured SQL query for each input row.

Read our Blog Post on Calling SQL Queries using SQL Transformation in Informatica Cloud:
https://thinketl.com/sql-transformati...

Topics Covered:
00:00 Introduction
00:44 Static SQL Query in SQL Transformation
05:05 Dynamic SQL Query in SQL Transformation
05:40 Full Dynamic SQL Query in SQL Transformation
08:45 Partial Dynamic SQL Query in SQL Transformation
10:49 Passive Mode in SQL Query in SQL Transformation
11:32 Conclusion
_______________________________________________________

Visit our website for free resources on Informatica Cloud and Snowflake
► https://thinketl.com

Join our community:
***********************
WhatsApp► https://whatsapp.com/channel/0029Va4Z...
LinkedIn ►   / thin.  .
Instagram►   / thinketl  
Facebook ►   / thinketl  
Twitter ►   / thinketl  
Sign up for our Newsletter ► https://thinketl.com/subscribe/
***********************