When I run the PROC SQL below in DI Studio, I saw that at the oracle log, two SQLs are executed.: PROC SQL; INSERT INTO ODS.ODS_CUSTOMER (ID,DESC) SELECT  ID, DESC FROM ORA.CUSTOMER WHERE ID IN (1,2); QUIT; SQL 1) SELECT  "ID", "DESC" FROM CUSTOMER WHERE  ( ("ID" IN  ( 1 , 2 ) ) ) SQL 2) SELECT * FROM CUSTOMER Can anyone tell me if there is the option to not execute the second SQL (Select * from)? As the table in question is very large, i'm having a performance problem. ... View more

I need abort a job if the source table of this job is empty or does not exist. Does anyone know how I can do this in DI Studio 4.6 within a job? ... View more

Is possible, using only transformations in DI Studio (without using programming), get the previous record of a data set and implement the logic below? Input: 1 a 1 b 1 c 2 d 3 e 3 f Output: I need to calculate a new column that uses the value from the previous record. 1 a   a 1 b   a-b 1 c   a-b-c 2 d   d 3 e   e 3 f   e-f ... View more