List of Contributions

Harshavardhan Peddireddy

Contact Details

My Content

1 to 20 of 25 total
Posted By Harshavardhan Peddireddy Tue March 01, 2022 01:42 PM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Team, Good Morning!! Did any one tried ODPP Masking functions over Powershell ? If yes please guide me how to access ODPP's over Powershell. ------------------------------ Harshavardhan Peddireddy ------------------------------ #InfoSphereOptim #Optim
Posted By Harshavardhan Peddireddy Mon November 08, 2021 03:14 PM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Archibald ODM support only discontinued not the product, so you can still use current product as is .. in case if you run into any issues with ODM product then we will not get IBM support as they are no more support the product. IBM also planning to come up with a Paid / Licensed version of ODM ...
Posted By Harshavardhan Peddireddy Tue August 17, 2021 11:39 AM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Krishna, Connecting Optim with MongoDB or AWS Databases is not something straight forward. You can use IBM Federation Server to create wrapper using the ODBC/JDBC drivers from Amazon DocumentDB/Dynamo. Optim treats this database via federation as DB2 database, which will allow Optim to ...
Posted By Harshavardhan Peddireddy Thu July 29, 2021 11:41 AM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Archibald, Use "Optim Connect Driver for ODBC 3.5 " and create ODBC connection on your local. You can access that ODBC connection on any Tools which accepts ODBC connection. I am using "Toad Data Point" Tool to access Archive files via ODBC. Let me know if you need more details. ---- ...
Posted By Harshavardhan Peddireddy Thu March 04, 2021 07:37 PM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Valentin, Instead of ROWNUM, use Where conditions to slit the volume into separate Extract files. Then apply convert on each Extract files. Here you have some ROWNUM known issues readthrough .. https://oraclefrontovik.com/2014/05/16/using-oracle-sql-doesnt-rownum-2-work/ https://blogs.ora ...
Posted By Harshavardhan Peddireddy Thu March 04, 2021 10:29 AM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Valentin, This happens when the Database which holds Lookup tables is down (even for a moment). Another instance is, when your job reaches internal memory maximum utilization, as your job holds SEED reference for each record. Try splitting job into at least two or three and try it will work. ...
Posted By Harshavardhan Peddireddy Wed September 30, 2020 10:17 AM
Found In Egroup: InfoSphere Optim
\ view thread
Thank you so much Katie for the prompt response. Sure I will share the details with Dave. ------------------------------ Harshavardhan Peddireddy ------------------------------
Posted By Harshavardhan Peddireddy Thu September 24, 2020 02:49 PM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Team, Greetings!! I would like to know if any one in this forum tried and succeeded to Mask Data in a NoSQL Database such as MongoDB ?? If yes please share us the procedure and steps involved. Appreciate your response.. Thanks ------------------------------ Harshavardhan Peddireddy --- ...
Posted By Harshavardhan Peddireddy Mon June 08, 2020 07:09 PM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Rohit, We have stored all the possible source values ​for ID_DESC field using ARRAYS. And using IF and Else statements, we have passed specific categories into two different masking algorithms within same LUA. Refer below links.. https://www.tutorialspoint.com/lua/lua_arrays.htm https: ...
Posted By Harshavardhan Peddireddy Tue May 19, 2020 04:11 PM
Found In Egroup: InfoSphere Optim
\ view thread
Hi All, We have used Arrays/Table concept in the LUA programming and solved the problem. Thank you.. ------------------------------ Harshavardhan Peddireddy ------------------------------
Posted By Harshavardhan Peddireddy Sun May 17, 2020 12:35 PM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Trong, Thanks for prompt response. The problem here is, when I deal with Health ID of 3rd Row ​- how to call Primary/original Health ID from first row into LUA script. The compare -- Parse -- Mask -- Concatenate -- Set as Target will happen only when I am able to bring Primacy Health ID into LUA ...
Posted By Harshavardhan Peddireddy Thu May 14, 2020 09:58 PM
Found In Egroup: InfoSphere Optim
\ view thread
​Hi All, Greetings!! Please have a look on below scenario and advise.. I have a table which holds Customer's different Heath Care ID's. Each ID and it's description is present in a different Row of same table ( Cust_ID is join factor ). Few ID's were derived from combination of couple of other ...
Posted By Harshavardhan Peddireddy Tue May 05, 2020 09:24 AM
Found In Egroup: InfoSphere Optim
\ view thread
Hi All, FYI Optim Product Development team created an iFix for this issue ( Both 11.3.0.6 and 11.3.0.8 ). If any one of you face similar issue, get in touch with IBM support for iFix. RCA from Optim Development Team : This logic problem is actually a length control error in Optim code path ...
Posted By Harshavardhan Peddireddy Tue April 28, 2020 03:02 PM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Jimmy, Thanks for your response. We are using Optim 11.3.0.6 version and Oracle 12.1.0.2.0​ I we are just trying Extract and Insert. ------------------------------ Harshavardhan Peddireddy ------------------------------
Posted By Harshavardhan Peddireddy Mon April 27, 2020 12:00 PM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Danny, Yes, we have opened a case with IBM.​ ------------------------------ Harshavardhan Peddireddy ------------------------------
Posted By Harshavardhan Peddireddy Mon April 27, 2020 10:38 AM
Found In Egroup: InfoSphere Optim
\ view thread
Hi All, When we deal with column's having "Number" Data Type with No precision and Zero scale ( Oracle DB ). Optim Extract job successfully extracting data only for 30 Bytes : 12345670551607123433666116255796 Data in the Extract file > 30 Bytes: 12345670551607123433666110000000 Sample Source ...
Posted By Harshavardhan Peddireddy Wed April 08, 2020 01:02 PM
Found In Egroup: InfoSphere Optim
\ view thread
Thank you so much Suraj, Yes, your suggestion worked. Adding some additional notes from trails. Just in case it helps others. What's new in 11.3.0 Fix Pack 5 Remove Clear Text Passwords for ODPP lookup functions in Lua. Lua Column Map procedures no longer need to code the password ...
Posted By Harshavardhan Peddireddy Tue April 07, 2020 01:06 PM
Found In Egroup: InfoSphere Optim
\ view thread
​Hi All, I am trying to write LUA script for FullName field using Hash_Lookup. we have a lookup table in one of DB Alias within our Optim Directory. I wanted to avoid passing USER ID and Password parameters in LUA scripts. Please advise the options. When I try the script without user ID and Pass ...
Posted By Harshavardhan Peddireddy Wed April 01, 2020 09:25 AM
Found In Egroup: InfoSphere Optim
\ view thread
​Hi Hari Try trim function str1 = optim.source.getcolumnvalue() str = str1:gsub(""%s+"", "" "") if (str ~= nil) then Your Lookup script ------------------------------ Harshavardhan Peddireddy ------------------------------
Posted By Harshavardhan Peddireddy Tue March 31, 2020 04:32 PM
Found In Egroup: InfoSphere Optim
\ view thread
Hi Trong To pick a specific part of string and mask, you no need to write LUA. You can use Affinity as is. Try below example : -- TRANS PRO=aff, algo=fpe, mtd=rep, key="xyzabcxyz", COPY=(1,4), COPY=(5,2), iterations=12, tweaks=no, flddef1=(name="Source field name", dt=varchar)​ ----------- ...