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-transformation-query-mode-in-informatica-cloud/ 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 ► https://www.linkedin.com/company/thin... Instagram► https://www.instagram.com/ThinkETL Facebook ► https://www.facebook.com/ThinkETL Twitter ► https://twitter.com/ThinkETL Sign up for our Newsletter ► https://thinketl.com/subscribe/ ***********************