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

Data engineering Interview Questions

1)  What all challenges you have faced and how did you overcome from it? Ans:- Challenges Faced and Overcome As a hypothetical Spark develop...