List of Contributions

Dhinmar James Cayog

Contact Details

My Content

1 to 15 of 15 total

RE: Data Transformation

Posted By Dhinmar James Cayog 05-23-2023 02:42
Found In Egroup: Data360 Analyze \ view thread
This worked! Thanks a lot! ------------------------------ Dhinmar James Cayog Knowledge Community Shared Account ------------------------------

RE: DB Execute Node Performance

Posted By Dhinmar James Cayog 05-19-2023 06:47
Found In Egroup: Data360 Analyze \ view thread
Thanks for your inputs Ernest. This is now resolved. Apparently, the performance issue happens when the query is returning null and it was resolved by implementing a sql plan from lower environment that successfully completed the query. ------------------------------ Dhinmar James Cayog Knowledge ...

Data Transformation

Posted By Dhinmar James Cayog 05-19-2023 06:41
Found In Egroup: Data360 Analyze \ view thread
Hi, I'm looking for a way to do the following data transformation within data360. I have an input data and I want to process it to have the following output: Input: Output: Appreciate any suggestions. Thank you! ------------------------------ Dhinmar James Cayog Knowledge Community Shared Account ...

RE: Unexpected Error Help

Posted By Dhinmar James Cayog 04-20-2023 11:59
Found In Egroup: Data360 Analyze \ view thread
Hi, Just to update on this, I was able to resolve this issue by using the JDBC Store node. ------------------------------ Dhinmar James Cayog Knowledge Community Shared Account ------------------------------

DB Execute Node Performance

Posted By Dhinmar James Cayog 04-20-2023 11:21
Found In Egroup: Data360 Analyze \ view thread
Hi, Good day! I would like to ask if you can provide insights or suggestions on the slowness we are experiencing in using the DB Execute node in Data360. As a background, the lavastorm job that runs the same node completes in under 3 minutes, while the migrated node to data360 is running for 3+ hours ...

RE: Identify records containing cyrillic characters

Posted By Dhinmar James Cayog 04-20-2023 04:12
Found In Egroup: Data360 Analyze \ view thread
Thank you! These ideas are great. ------------------------------ Dhinmar James Cayog Knowledge Community Shared Account ------------------------------

Identify records containing cyrillic characters

Posted By Dhinmar James Cayog 04-18-2023 12:41
Found In Egroup: Data360 Analyze \ view thread
Hi, I want to use a split node to separate records containing cyrillic characters. For example. If Field1 has a value of "System of a Down - Официальная Дискография [MP3]", I want it to go to the false output pin of the split node. Any recommendation how to achieve this? Thank you. ------------------------------ ...

RE: Use Oracle Sequence and add to incoming data

Posted By Dhinmar James Cayog 03-31-2023 09:45
Found In Egroup: Data360 Analyze \ view thread
Thank you Peter. ------------------------------ Dhinmar James Cayog Knowledge Community Shared Account ------------------------------

Unexpected Error Help

Posted By Dhinmar James Cayog 03-31-2023 08:01
Found In Egroup: Data360 Analyze \ view thread
Hi, I'm receiving the error prompt below whenever I execute the DB Store Node. Though after closing the dialog box, I can see that the record are being inserted. I have 3 non-nullable columns in the target table, of which 2 are string. But before the DB Store node, I can see that the incoming records ...

Use Oracle Sequence and add to incoming data

Posted By Dhinmar James Cayog 03-24-2023 15:09
Found In Egroup: Data360 Analyze \ view thread
Hi, I want to insert incoming records from transformation node to "TABLE_A" using DB Store node. But before I insert it to "TABLE_A", I want to add the database sequence used by "TABLE_A" as ID. That would be something like this: Incoming column A column B A1 B1 A2 B2 A3 B3 ...

HTTP Header

Posted By Dhinmar James Cayog 03-08-2023 06:03
Found In Egroup: Data360 Analyze \ view thread
Hi, Can you please guide me how can I convert this from Header to Header (from Field)? It is working using Header option but I need to use Header (from Field) to make the value dynamic which is needed on another http node. Header: client_id: a1b2c3 client_secret: d4e5f6 I tried to do it like ...

Equivalent of Default Emit in Data360

Posted By Dhinmar James Cayog 02-17-2023 04:57
Found In Egroup: Data360 Analyze \ view thread
I want to output column Address as null if that column is missing in input. In LAE, we do this by default emit (null) as Address How do I do this in Data360? Thank you so much. ------------------------------ Dhinmar James Cayog Knowledge Community Shared Account ------- ...

RE: Fetch XML from Database

Posted By Dhinmar James Cayog 02-13-2023 07:26
Found In Egroup: Data360 Analyze \ view thread
Thanks Peter. It is working now after configuring the DbUrl under Advanced :) ------------------------------ Dhinmar James Cayog Knowledge Community Shared Account ------------------------------ ------------------------------------------- Original Message: Sent: 02-10-2023 07:53 From: Peter ...

RE: Fetch XML from Database

Posted By Dhinmar James Cayog 02-10-2023 07:07
Found In Egroup: Data360 Analyze \ view thread
Thank you Peter. I really appreciate your help. I'm very new to Data360 as I only started a week ago. I'll try to ask some colleagues on how to configure the JDBC Query node. ------------------------------ Dhinmar James Cayog Knowledge Community Shared Account ------------------------------ ...

Fetch XML from Database

Posted By Dhinmar James Cayog 02-08-2023 03:46
Found In Egroup: Data360 Analyze \ view thread
I'm trying to fetch an XML stored in a database table using a DB Query node with an intent to use an XML Data node afterwards to convert it into tabular form. Is there another way to implement the logic above or a way to resolve the issue below when fetching the column with CLOB data type using ...