This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
pranil2k2
Contributor
since ‎01-26-2018
‎07-25-2023

User Statistics

  • 54 Posts
  • 2 Solutions
  • 0 Kudos given
  • 3 Kudos received

User Activity

Get minimum date from set of column values

05-12-2021
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...

IF else Condition in Mapper

03-31-2021
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...

JSON Splitter for an Split column

03-27-2021
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...

Update statement in Oracle excute for JSON format

04-16-2020
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...

Count of successful rows from Oracle Merge

04-14-2020
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...
View more