Monday, April 20, 2015

How to Refresh Parameter File On Run though Query

SELECT DISTINCT 
B.SUBJECT_AREA, 
B.TASK_NAME AS SES_WF_NAME, 
A.ATTR_VALUE AS PRM_FILE_PATH 
FROM 
OPB_TASK_ATTR A, 
REP_ALL_TASKS B 
WHERE 
A.ATTR_ID IN (1,4) 
AND A.TASK_ID = B.TASK_ID 
AND A.ATTR_VALUE LIKE '%.prm%' 
ORDER BY 1,2 ASC 

This query will give you all the sessions where your param being used, 
now once you get the access on Informatica repository get update the entries for old file by new one. 

No comments:

Post a Comment

 BEST PYSPARK LEARNING SITES https://www.youtube.com/watch?v=s3B8HXLlLTM&list=PL2IsFZBGM_IHCl9zhRVC1EXTomkEp_1zm&index=5 https://www...