topic How Can tDBRow Other Database!? in Talend Studio

How Can tDBRow Other Database!?

Anonymous — Sat, 16 Nov 2024 02:12:40 GMT

My Query(tDBRow)

DROP TABLE IF EXISTS CSTMRDB.CSV100_rown;
CREATE TABLE CSTMRDB.CSV100_rown
AS
SELECT ROW_NUMBER() OVER( ORDER BY A.cust_id) AS "NO", A.*
FROM DEV2.CSV100 AS A;

usually, if i need sql query(update, delete, create ...)

i used tDBrow. but this have one target DB

but my query is using two DB( CSTMR, DEV2 )

is it possible?

Re: How Can tDBRow Other Database!?

Anonymous — Mon, 08 Jun 2020 06:59:16 GMT

personally i solved sorry

Re: How Can tDBRow Other Database!?

Banupriya — Thu, 09 Mar 2023 20:03:06 GMT

Could you please share the steps?I want to load data from one (source) database to another (target)database using insert query in tdbrow. But I can select only one db connection in tdbrow. How to achieve this? It's giving the error table does not exist because I have selected the target db connect so it's failed to get data from source DB.