I have a SQL Script with multiple drop & create DDL(Create tables As Select , I want to run them at one go. I am quite new to informatica powercenter, can some one provide the process of using SQL transformation for BigQuery in informatica.
Sample Query:- informatica transformation