DSXchange

No. That derivation is testing for null and when it is null is setting the output to a single space. Also, there's no reason to do any kind of a test if the input should be passed along unchanged, null or otherwise, which is what your proposed modification would (in effect) do.

Oh, and just for the record - what I posted does not nor is it meant to handle physical deletes from the source system. That requires either a second pass in the opposite direction or a full outer join between the source and the target rather than the technique mentioned above.

They are not "out of the box" routines which is why you couldn't find any mention of them. Rather they are 'user defined' routines, ones someone in your shop wrote. You'll need to locate them in the Manager and when you find them double-click on their name. That will allow you to see their...

InfoSphere DataStage Parallel Framework Standard Practices This was actually released a couple of months ago, then pulled and re-released "officially" recently. And for some reason your link doesn't work well for me, Adobe Reader loads 7MB of nothing and then errors out. This link, howeve...

OK. :? Let me be the first to admit that I am finding it harder and harder to understand what your issues are in this thread or how anyone could possibly help you more than we've already done. Let me make one last stab at it as I am in a giving mood this morning... In a type 2 dimension, there shoul...

OK... at this point I think we'd have to see the PL/SQL or at least enough to know what it is doing with the DATE field. Are you certain that you actually "need" the time as well, seeing as how it works when you don't include it and complains when you do?

What 'update action' are you using on the link that should be updating? I'm guessing it's not set to update.

Your sql example's syntax is bad, hence the error. Regardless, if all you need is a date, modify the example given to you so that it produces a date rather than a timestamp, see if that helps:

Not quite sure what you are asking. The 8.x release has a tool that you feed two job names and it compares them and gives you (from what little I remember) a nice report of the differences.

vinothkumar wrote:I think you can tweak the below query running in Universe tables for your need.

That looks very... Duke like.

eostic wrote:Metadata Workbench can provide you with this information also, by doing a query that looks at "Stage Columns"....which are effectively, Columns-on-a-link.....

And that is available in the 7.x release?

If you have stored your table meta data in the repository and loaded it into the job then the first option does exactly what you need. Otherwise, you've got no other option but a search of the dsx. Well, except for things like Chuck Smith as written, he has a utility to parse a dsx and I've modified...

So... did you ever bring support into the picture? Have they tried to figure out what in the heck might be going on? Seems like you are well and truly into their terrritory now.

The Usage Analysis tool in the Manager, perhaps, its icon looks like a 'beaker'. That or by searching a dsx export of the project.

Index() is one answer, Field() would probably be simpler. Fetch the first field from a "@" delimited string and if that fails, try "/", then space. Etc.