Forum Stats

  • 3,873,457 Users
  • 2,266,576 Discussions
  • 7,911,542 Comments

Discussions

How can i view e$ table records?

665235
665235 Member Posts: 12
edited Nov 5, 2008 8:11AM in Data Integrator
Hi All,

I had some constraints declared in target data store. In my interface i can see some records have been moved to e$ table.

i want to see those records. how can i see that?Please help...
Tagged:

Best Answer

  • 237437
    237437 Member Posts: 240
    Answer ✓
    Goto ODI Model from Designer --> YOUR DATASTORE (Right click) --> Controls --> Errors

    or

    Ensure that in IKM (Delete Temporary objects is SET To False). You can query it in Target schema. select * from E$_<TARGETTABLENAME> (unless and until during installtaion you have not changed the prefix for ODI).

Answers

This discussion has been closed.