DSXchange

Why yes, yes it does.

You could "insert this constant" as you noted or I believe (it's been awhile now) you could simply hardcode the key value inside the lookup.

Lookup comes to mind.

And welcome.

I've never really understood the desire to completely change horses in the middle of the stream. It hardly ever works with gaming companies and the engine they use and I've seen warehouse projects go down in flames for it. And as Mike noted you'll probably just end up back where you started (in a co...

I don't really think there is anything you can save from your DataStage world that can be directly leveraged in Informatica. For the metadata you'll want to import that using Informatica from the actual sources rather than a dump of the DDL, for example. About the only thing I can suggest is make su...

Of course, and you have a couple now.

How much does it matter that it isn't really XML but rather HTML? I was wondering if you could parse it as XML but you would need to make it "well formed" before hand I would think.

The first technical term that comes to mind is... yuck. :? I don't see a good way to "manually" do this but perhaps others may have some suggestions. I would imagine you may need to leverage one of the many "HTML Parsers" out there or perhaps write something in C++ or Java. [shrug]

Sorry, I'm not your question target audience but am willing to make a guess. I'm assuming you could do it either way, depending on your starting version. If you actually have all of the connectors in your older project, you could run the tool before. Failing that where you are moving to a version wh...

Seems to me the first answer is "depends". Can you post an example of the HTML and what data you are trying to extract from it, please?

Well... the obvious answer would be to install in on a supported operating system. Failing that, perhaps contact support and see if there are any 'compatibility' type settings that might let you override that restriction.

A search online for "java.net.SocketTimeoutException" overwhelmingly suggests you increase the timeout value. Where do you do that? I have no idea but I would imagine someone here does.

Also, please advise if i can run CLEAR.FILE for whole project? As in all at once? No, not that I've ever seen. It is strictly one by one. For your "unnecessary" ones I suppose you could write a script to check the directory age and then run CLEAR.FILE on the ones that meet your criteria. ...

Yeah, even after all these years I didn't think there was another approach for a massive update like this so put that out there...

We can't modify every job. I assume you meant manually or one by one. Obviously you'll need to modify every job. There will be effort and risk so I would make sure you have good backups before proceeding with any effort of this nature. First thing that pops into my head is a dsx export of the entir...

To kill the first two birds with one stone, doing a "ls -m" should get you your list of files directly in a comma delimited list.

Since you didn't mention it, what about the extended properties - was that something you were able to set?

Also note that, once that is set, your conversion should be StringToTime(InputCol,"%hh:%nn:%ss.6")