DSXchange

Hi, I have a datastage project, in which, from oracle tables, I write on sqlserver tables. The server is on unix machine. The insert statement, via odbc stage, doesn't work. Among the fields target to load, there are sqlserver datetime and timestamp. I do not know how to convert timestamp datastage ...

Hi, I have two project: the first (devel) under /opt/IBM/InformationServer/Projects the second (prod) in other directory, like /u/... So, I have the same job in both two project. When I execute: dsjob -jobinfo DEVEL_PROJ job I obtain correct result ; otherwise, when I execute dsjob -jobinfo PROD_PRO...

Hi, I'm using dsjob -jobinfo to obtain statistical information about jobs. The command does not give errors of execution, but the result is always the same, namely: Job Status: NOT RUNNING (99) Job Controller: not avalaible etc. .... The problem is that the job was executed successfully. The project...

So simple!
Thanks

Hi, I am writing for advice. In a transformer, I carry out checks on inputs, for example on the formal correctness of the dates. I have to concatenate in a new column in output, only the values of columns that do not pass the checks I mentioned above. I use the variables stage, but I do not know how...

I had also thought about a similar solution, using the stage variables.
I was hoping, instead, that the column metadata of the stream were intercepted in some way, rather than enhance them by hand.
This can be considered a workaround.
Thanks

Hi, I write for information. I have a ETL, that at some point in a transformer stage makes formal checks on the data. Data that fail these checks must be discarded. I add some control fields in transformer. Among these I'd like one that contains the field name for which I need to control. Is there a...

Thank you for your reply.
Where can I find this tool?
How does it works?
Thanks again

Hi, I write for advice. I have to make an estimate of resources (in terms of disk space needed) required for a DataStage server (parallel jobs). In my project we will have about 10 GB of input data, divided in several files. How much space for DataSet? How much space for the scratch area? There is a...