DSXchange

Not really, at least not "out of the box". Ken Bland did write a series of interesting utilities that (amongst other things) could do this for you based on a wildcard pattern. I *think* it may have been posted here, once upon a time but don't recall for certain. The answer could also depen...

How are you trying to accomplish this? Regardless, you need to build a process to read them out of the log tables and then store them in your archive of choice, be that flat files or database tables or what have you. You'll find lots of posts on this subject and "ETLStats" will come up in ...

Only populate the hashed file with "current" records i.e. ones where your current indicator = 'Y', something I thought you said you were already doing.

That's... odd. I've got no clue what might be going on but edited the title of your post slightly to see if we can attract the ever so knowledgeable Ernie.

As noted - the database. Have your DBA monitor things for you.

The target is oracle table and the datatype is integer, so in the target i want the value to be 03 Sorry, but it doesn't really matter that is what you 'want', leading zeroes are not stored in any kind of numeric field. As noted, however, you can make it look the way you want when you extract it wi...

Roll your eyes all you like, that *is* your answer. Search the forum for "dssh" to find examples how to fire that Universe query from the command line, the exact same query you would use at a TCL prompt or from the Administrator client. And don't forget you can always use the Director for ...

Stick with command line file transfer utilities for things of that nature.

It would help if you expanded your question a teeny bit - "search the job in UNIX"? Can you explain what you mean by that so people don't need to guess? Or perhaps this might help:

viewtopic.php?t=136147

First suggestion - the Sequential File stage is not a good choice for XML. Use an External Source stage to get the XML filename(s) and then let the XML Input stage do the actual reading of the file as outlined here.

In a Server job? PX, perhaps, but not Server.

In other words:

a) That's how it works
b) It's not all that useful

That isn't what was suggested.

But first it needs to be found.

dr.murthy wrote:instead of comparing dsx/xml files is there any other way to do this?

Nope, not until you get to 8.x I'm afraid - it comes with a lovely GUI comparison tool.