top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Informatica Metadata Exchange (MX) Views show the object deleted

0 votes

I used the PowerCenter Metadata Exchange to query.

There is a view REP_ALL_SOURCES who can provides a list of the latest version of sources defined in each folder of a repository.

But when i used this view, i find that it shows the sources deleted too. I did't find the field who can filter the object deleted. so for REP_ALL_MAPPINGS, REP_LOAD_SESSIONS are the same.

Anyone can please tell me how to show the object only exist?

posted Jan 2, 2015 by Sunil

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

1 Answer

0 votes

In repository manager, choose the particular folder. Then go to Versioning -> Find Checkouts. This will give you the list of objects that are checked out including the deleted objects. Select the objects that you deleted and then check-in.

answer Jan 6, 2015 by Shweta Singh
Similar Questions
+1 vote

Couple of tables in our Database doesm't have any key. However, key was created in target table at informatica level.

Now my need is,I want to identify informatica metadata table where I can find target table and corresponding column name marked as key.

These tables are created long back,not sure why it was created like that. We planed to add primary key at database level so to identify the primary key .I want to look for informatica metadata tables

Kindly suggest

+1 vote

In my mapping I have one power exchange target, in which header and trailor record type are having low and high value. Without changing the datamap can we write low and high value through informatica?

0 votes

Currently datasets are getting generated in MF if there are 1 or more than 1 records coming from source. If there are no records from source, then empty data set is not created in MF.

As a solution, we tried to give pre-sql in session specifying all basic properties. But still our session failed with the below error:

Message Code: PWXPC_12015 Message: [ERROR] Error message: 
[[Informatica][SCLI PWX Driver] PWX-00265 DBAPI Error. DB_EXECSQL failed for file . 
[Informatica][SCLI PWX Driver] PWX-01275 DBNTC ExecSQL failed for file , rcs 260/265/0.]
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.