DSXchange

I don't think anyone's code will do what you need. Because your logic spans lines, I'd think that writing a DS/BASIC program that reads a whole .DSX file to a dynamic array, which you can then process by searching for tokens, might be the easiest approach. If you declare the folder which contains th...

During which part of the Windows install do you get this message?

Sounds like you have a reproduceable test case to submit to your support provider as a bug; albeit not a high-priority one as you've already discovered the workaround.

DataStage creates an applet in the Control Panel {I can't recall what it is called, probably DataStage} which lets you do this.

I think the best place to get those types of questions answered correctly is in the Informatica forums, perhaps at the Informatica developer network.

Craig - thanks, I was so much in DataStage mode that I assumed the "connect" meant database connectivity. My bad.

If you can't access Ken's code you can code it in DataStage without too much effort. I have used this kind of resource control extensively, in fact I'm monitoring a job right now that takes the number of instances to run in parallel as a parameter. You cannot use the Job Activity in a sequencer, sin...

Are you 100% certain that your dataset is being created with the same metadata and parameters as in your job which reads it? It sounds like you are missing a column definition.
You can view the dataset's schema in DataSet management or with the UNIX orchadmin command.

vpauls,

I'm not sure I understand what you mean by "schema" in this context. Does this mean the job itself is on different servers with different userid/passwords? Or that the job runs on one machine, but you login to different database schemas? Or something entirely different?

What (stage type) are you looking up from and how have you declared whether it is a normal or a sparse lookup?

The PX Documentation contains several chapters on connecting PX and Oracle via different methods on different platforms. What specifically are you asking?

Colin - think recursion I often write either a DS/BASIC program (as a routine) or a DataStage job to do this kind of mass conversion - I read the .dsx file as input and create a new .dsx outpt and do the logic within DataStage. Alternately I will use EMACS, which allows for very simple macros to be ...

You won't get a timestamp unless your format string matches your data. Try formatting with '%yyyy%mm%dd %hh:%nn:%ss' and making sure your input string also has a dummy time part added to it. i.e. StringToTimestamp(DSLink2.MBR_DOB_DT:" 00:00:00","%yyyy%mm%dd %hh:%nn:%ss")

The builtin date manipulation routines let you do this easily - but you need to know how to handle such situations as "03-30-2003" minus one month. My favored approach is to use the 1st day of the month (every month has one) and then, once I get the answer, subtract one day to get the last day of th...

If you can do it in a UNIX script then the easiest way to do this in windows is to install a (free) toolkit such as MKS and just run your scripts directly under windows..