Jump to content
We've recently updated our Privacy Statement, available here ×

tMap - skipped record sets of inner join


CrazyBird

Recommended Posts

Hello!

I have the following situation:

I have a positional file and a databse table and join them togehter (file is main, db table is lookup) using the inner join option.

It's clear, that in this constellation there are only arriving sentences in the output where there exists data in both, the db table AND the file.

But now I need to know which data records have been skipped out from the postional file because they where not able to be joined for logging purposes (because this is a data error of the input file).

Is there any possibillity to do this?

 

Thanks in adavnce for your answers,


Stefan Mackovik

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...