User Activity

Hi, I have a typical requirement, where i need to find the Min ETL run time from below set of data. I tried to convert rows into columns but there is no common field to do group by. i tried different options but nothing worked for me The desired ou...
Hi , I have a requirement to write multiple IF/ELSE conditions and generate an output column. but i am getting syntax error, please someone correct me $section == “Presentation” && $action_field == “Product Short Name” ? $EMA_PRODUCTSHORTNAME: $secti...
Hi, I have a requirement to read multiple XML files data and load into Oracle table. I am using Directory browser to read the list of XML files and passing the path to File reader and then XML Parser, from XML parser the output is given to mapper the...
Hi, I have an requirement to save the JSON column value in an Oracle DB. I am trying to use Oracle execute to design Update statement. I am using below syntax, but it is throwing error. I think did we need to extra cautious to handle single quote and...
Hi, I have a requirement to record the successful row count from Oracle Merge Snap. this is to maintain the Data Log table. Is there any way to know the successful rows from Oracle Merge. i saw something in Mapper (snap.out.totalCount). Please someon...
Kudos from