Informatica MDM - How to identify MDM Rowid in AVOS schema
In this video tutorial we will understand how MDM Rowid Object value linked in AVOS schema in detail.
You can visit Informatica MDM related videos here: • 00. Informatica Master Data Managemen...
Website: http://guru4technoworld.wix.com/techn...
Facebook : / a2zoftech
Website: www.dronatechnoworld.com
Udemy course: https://www.udemy.com/course/informat...
For reference, here are the sql statements used in this tutorial -
SELECT TP1.PROCESSID, TP1.PARAMETERID, TP1.STRINGVALUE AS ROWID_OBJECT, T1.SUMMARY, PH.PHN_NBR
FROM AEB4PTASKPARAMETERVALUE TP1
, AEB4PTASK T1
, CMX_PRTY.C_B_PRTY P
, CMX_PRTY.C_B_PHN PH
WHERE T1.PROCESSID=TP1.PROCESSID AND TP1.PARAMETERID=33
AND TRIM(P.ROWID_OBJECT) = TRIM(TP1.STRINGVALUE)
AND P.ROWID_OBJECT = PH.ROWID_PRTY;
-- Step 1. Get ProcessId (Process State - 1 : Unclaimed, 2 : Claimed , 3 : Started , 4 : Completed )
SELECT PROCESSID FROM AEPROCESS; -- Optional where clause to check Process State -- 128605
-- Step 2: Get Process id from child process
SELECT PROCESSID FROM AEB4PTASKPA WHERE PAPROCESSID ='128605';
-- Step 3. Get Parameter ID corresponding to berowid
SELECT PARAMETERID FROM AEB4PTASKPARAMETER WHERE PARAMETERNAME='berowid'; -- 33
-- Step 4:
SELECT STRINGVALUE FROM AEB4PTASKPARAMETERVALUE WHERE PARAMETERID='33' AND PROCESSID='128607';
Watch video Informatica MDM - How to identify MDM Rowid in AVOS schema online without registration, duration hours minute second in high quality. This video was added by user Sandip M 25 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 17 once and liked it people.