top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica Metadata Exchange (MX) Views show the object deleted

0 votes
486 views

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
+2 votes
Informatica metadata table - Primary key column from target table

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

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

Kindly suggest

0 votes
Informatica metadata table - Primary key column from target table

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

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

Kindly suggest

+1 vote
Informatica metadata table - Primary key column from target table

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
How to write low value and high value in power exchange target in informatica?

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
How to generate empty data set in mainframe through Informatica Power Exchange?

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.]
...