top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Invalid Sessions Query of Informatica

0 votes
208 views

I want to do some cleanup in my project folder of Informatica. I need to find the list unused sessions/obsolete sessions in the folder. I am not able to get the correct set of record with the following query:

SELECT DISTINCT * FROM REP_ALL_TASKS A, REP_SESS_CONFIG_PARM B
WHERE A.TASK_ID = B.SESSION_ID AND TASK_TYPE_NAME = 'Session'
AND B.ATTR_ID = '202' and is_valid <> 1
AND A.SUBJECT_AREA like ('folder')
ORDER BY 1, 2

Can anyone help me?

posted Nov 11, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

Replace AND A.SUBJECT_AREA like ('folder') with AND A.SUBJECT_AREA IN ('folder') or AND A.SUBJECT_AREA like 'folder'

answer Nov 14, 2014 by Shweta Singh
0 votes

try this -
SELECT DISTINCT * FROM REP_ALL_TASKS A, REP_SESS_CONFIG_PARM B
WHERE A.TASK_ID = B.SESSION_ID AND TASK_TYPE_NAME = 'Session'
AND B.ATTR_ID = '202' and is_valid <> 1
AND A.SUBJECT_AREA like 'folder'
ORDER BY 1, 2

answer Nov 14, 2014 by Shatark Bajpai
Similar Questions
+1 vote

I am facing below error while validating XML file using Java utility, below is error message :

An invalid XML character (Unicode: 0x{2}) was found in the value of attribute "{1}" and element is "1a".

for validation I have used XMLspy however it has gave up to open file because of its huge size, please suggest how we can find this invalid character.

+3 votes

Using Informatica 9.1.0

Scenario

Get the Dimension key generated and inserted to the Fact table from the Fact load.

I have to load the Fact table with a dimension key along with other columns. This dimension record is created from within the same mapping. There are five different sessions using the same mapping and executes simultaneously to load the Fact table. In this case I'm using a dynamic lookup with 'Synchronize dynamic cache' enabled to get unique dimension records generated from the 5 sessions using some conditions. The dimension ID is generated using the Sequence-ID in associated expression of the lookup. When a single session alone is run it worked perfectly fine. But when the sessions were run parallely it started to show unique key violation error as random sessions tried to insert the same sequence which was already there.

To fix the issue I had to give persistent lookup cache enabled and Cache file name prefix. But I did not find this solution or this issue in any of the forums or in INFA communities. So not sure this is the right way of doing it or this is a bug of some kind.

Please let me know if you had similar issue or some different thoughts.

Thanks in advance

0 votes

I have a SQL transformation with 2 ports. I want to insert the value of these ports to a table, however I am getting an error from sqlError port.

Below is the query I am writing in the source qualifier:

INSERT INTO A values (~QC_CODE~,(~QUERY_STRING~));

The QUERY_STRING port contains a sql statement which is executed on Teradata and results have to be inserted in the table A.

If I replace the first port in the above query with a constant value, I get correct results. Below is the query that gives correct result:

INSERT INTO A values ('1',(~QUERY_STRING~));
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...