DSXchange

Option 1 ---------- Read the file using sequential file stage with delimiter comma. Then use a following column import stage, there you can specify pipe as a delimiter to further split into columns Option 2 ---------- Read the file with just one column of length varchar 500 or something 1.e. read li...

In the XML output stage you must have mentiond a trigger column i.e.adresstype / city or anything. Either you can change that to an emp id... or group as whole... are you getting these address from multiple datasets ? if that is the case, then you need to create XML chunks and join with the key colu...

I have my source code developed and tested in the development environment. I want to deploy this code (only executables) in the QA enviroment and the requirement is, the deploment team is unix guys. All they expect me to do is, provide a dsx/source code file, and a script that will automatically rea...

why don't you give a try.

It should be able to read a dataset simulationusly by many process.

Normally all XML parser's can read an empty tag in the format <empty/> which is equalent to <empty></empty>. May I know the files you produced, are you viewing through any browser like internet explorer / mozilla etc.. if yes then it will by default show you in the format <empty/> but if you open th...

Hi, We have a requirement to access java services from Datastage. Is it possible? How to do that? We have a file in the following format ColA,ColB, ColC 100, X, Y 200,B,N I want to call a javaservice (its not webservice) e.g. ValidateCNCode(100,X,Y) and capture the return object of that service (it ...

In my case...

I want to check if it the incoming value is interger or not , float or not, etc...


I browse through the functions availabe and I couldn't see any function that check the data type of a field and return True or flase...

pls help

Hi I have a situation where I would like to get some ideas to crack. id, sales_date, desc, qty 1,'2008-10-9','suzki',100 1,'2008-10-9','mitsu',100 1,'2008-10-9','jaugur',100 1,'2008-10-9','aston',100 The requirement is to validate the format of each record and datatype of each record and if it did n...

How is it in Windows installation of Datastage?

I am not aware of any datastage stage where we can read a pdf...

please suggest if you know anything...

Thanks in advance

Hi..

Is it possible to read data from PDF (Acrobat) files using datastage.


Please help me.

It's very very very useful information...... Mainly debugging help you mentioned....

Thanks....

Hi ray.... I am facing the same issue and I tried outField:int64=decimal_from_string(stock_num) but not working. Warning: Sequential_File_2: When checking operator: When binding output interface field "stock_num" to field "outField": Conversion from source type "string[max=1...

Ari.. I recompiled the job and it did successfully. You know what that job does, I wanted to read whole text file content in a string. So I have none as final delimiter and give ~ as column delimiter where both are not possible and write that to a peak. I re run the job and its showing the same beha...

I have an unusual situation here. I have a job, I ran the job from Designer. The job shows completed in Director, I saw the logs, everything looks fine. But When I check the monitor of the same job, the stages still shows its running. The performance statistics in designer is still on "blue lin...

I am having 8.1 installed on VMWARE player. My server has got just 6 GB RAM. But it does well. Like ray suggested, my advice is also to increase the virtual memory size. It should do well. My configuration is Windows 2003 Server Enterprise VMWARE player 8 GB RAM , VMWARE allocation is 6 GB Virtual m...