DSXchange

I have been hearing about Informatica Grid recently as an alterantive to Ab Initio and EE. Anyone here have any working experience with it. I have used all 3 tools but have never used the Grid version of Informatica.

One of our jobs in a batch is using up a lot of scratch space. We can pinpoint by running one at a time but that will be time consuming. Is there a variable or soemthing which allows each job to name the temp files in scratch directory via a prefix or suffix. This was it would be easy for us to tell...

Thanks ray,
I am almost positive the DB is on a separate server but will confirm tomorrow.

We have imported some jobs from 7.5.2 to 8.0. Job compilation is very slow. Even jobs with say 3-4 stages take about a minute or so to compile. These used to take 3-4 seconds in 7.5. Has anyone seen this. Any tips to improve compile time. Searched for postings using "slow compile' compile speed...

7.5.x2 runs on windows 2003 server.
See following post for more details

viewtopic.php?t=100614&highlight=windows+server

Thanks craig. Actually that helps a lot. We do have a failure rate of 1 in say a 1000 due to resource contention of DB. IBM is investigating that issue. This is probably causing auto-purge to reset.
I will look for the utility.

Yup, dscc on client is not going to help.
Also I don't think compile actually deletes the logs.
So it is bck to deleting logs or finding out scenarios in which auto-purge stops.

Is there an new option to compile from command line or any other way I can do it in the script. That would be good option. Yup agree someone may have done a clear status or something.
I can always ask the admins to compile whole project once a week or so. But it looks a bit of a Hack.

1. We are executing in a loop for about 100 instances. 2. Now this has been running for the last 2 months non stop and we recently noticed that timings had increased from running all 100 instances in 5 mins to about 1 hour. In looking deeper we found they were being run sequentially. Yesterday we st...

We are running muliple instance job with mulitple instances and we need to run them in parallel. But each instance seems to be waiting before the next instance starts. We are not using the -wait parameter. Anyone seen this. Here is the command. Any help would be papreciated. dsjob -run -param ETL_PR...

The two migrations I have seen are reduced licensing cost. For the most simplest of AB Inito jobs the migration can be done cost effectively. For anything which use things like dynamic metadata, conditional components, scans, continuous, xmls etc etc the migration cost is high, but depends on the nu...

RCP in datastage is very limited. What you are asking you will have to be done with transformers and/or modify stages or with custom operators using osh but even then it may not be the same and you may end up with a custom job per source-target. In DS it is easier to hardcode than do highly paramete...

In Enterprise edition the two features that come close to the dynamic metadata supported by abinito are schema files and runtime column propogation. There are quite a few restrictions to this though e.g. it is one way i.e. you can't use schema files like you can use dml files on the output side. RCP...

I didn't see the answer to this question through searches. Am I assuming correctly that this is currently not possible in Datastage and I will have to write an extternal routine using icu etc and call it thru datasatge. In general the question is like this: If my data contains in one row date1,timez...

Thanks kumar. I had tried both ' ' and " ". Will try aging and see if I missed soemthng. Yes am currently putting tr in the filter while writing and reading. One thing I notices though is while writing if you have 2 seq files and if you put tr on both my job seems to hang as in, it doesn't...