Multiple Teradata Query in a SQL Transformation Informatica
I am working in Informatica 9.1 and using Teradata as DB. In my mapping I am using a SQL transformation for inserting the data to TABLEA from TABLEB(the insert is done using the values from our control tables, ie the query is build by the control table. We are just providing the query to SQL Trans.).
BT; INSERT INTO TABLEA SELECT COL1,COL2,COL3 FROM TABLEB; UPDATE CTRL_TBL1 SET INSERT_COUNT=(SELECT COUNT(*) FROM (SELECT COL1,COL2,COL3 FROM TABLEB)x); ET;
In the above query I am inserting data into TABLEA and UPDATE my CTRL_TABLE with the count of rows inserted.
My problem is TABLEA , TABLEB are in SERVER1 and CTRL_TABLE in SERVER2. in this condition how can execute the script using a single SQL transformation, whether can I use CONNECTION STRING inside the SQL script along with table..
So can we address the above set of quries with the server name ie SERVER1.DB_NAME.TABLEA