DSXchange

do u have any contstraints in Transfermer Stage. I have used IF THEN statement in a couple of places in the transformer If DSLink5.name='input1' Then DSLink5.value ELSE '' --column1 If DSLink5.name='input2' Then DSLink5.value Else '' --column2 I am redirecting the same column (DSLink5.value ) to tw...

Hi, I am giving the o/p of XML input stage to a transformer i/p.and the transformer is connected to a seq file stage. when I step all the colums in all the stages NOT NULL I am getting 2000 rows out of each stage.which is expected result. But requirement is that we need to have as many colums nullab...

Hi, I am facing a problem while imporing table definition in XML input stage. I am using an XML file as input to the importer.I dont have XSD file corresponding to this XML file. Now the problem is,some of the columns visible in the XML file are not shown in the XML metadata importer.please provide ...

Hi, we have a single line xml file which needs to be split into n no of rows. like.. for a file like this.. <?xml version="1.0" encoding="UTF-8"?><!-- BusinessObjects Data Integrator generated XML --><!-- 2008-03-27.11:39:27(388,858)[1] --> <OUTFILE><FF_XML_0001><version>1.1</ver...

Hi,
Can I use a regular expression stating the trimming criteria inTRIM function.

I have a requirement to trim the non numerals values of acolumn in a transformer stage.
can any one provide some inputs for my problem??

Thanks ray..

Hi I have a requirement where I need to keep perform arithmatic operations on 5 i/p columns of a transformer stage.which cannot be done in a single step. is there any way,I can write a custom function in datastage where I can use intermediate results for further processing and finally place the desi...

dspxlearn wrote:By default we don't get '+' signs for any positive calculations as we get '-' sign for negative values.
If your requirement is to have an '+' sign simply concatinate '+' to your calculation result. But, your target data type should be of Varchar/Char type.

and any idea about precesion ??

Hi, I have a SQL statemet like select trim(to_char(((( 46900.69 - 46057.79 ) * 36500 ) / ( 46057.79 * to_number(to_date(20080624,'yyyymmdd') - to_date(20080601,'yyyymmdd')) ) ) - ( 0.0734 * 100 ),'s999.9999999999' )) from dual whose out put looks like this +21.7027667540 Now I need to implement simi...

Hi, First you send the contents of file f2 to funnel , then send the transformer output to the funnel. Set Funnel Type to "Sequence" in stage properties page. Ensure the link from file f2 is the link 0 in "Link Ordering" tab of the funnel properties. Then direct the output of fu...

Hi, I am struck while using a funnel stage. I am writing the output of a transformer to a sequential file say f1. I have another file f2 which I need to append to f1 at the begining. for this I tried using a funnel stage.It didn't work because sequential file can have a single inputlink or a single ...

I have removed all properties in the [Format] tab of sequential file stage and added these two: Record level: Record type=implicit In the Field defaults: Delimiter=none I tried putting Final delimiter=end but any of these things didn't work. At one place the job got aborted saying that "one or ...

Hi ,
Can I use a sequential file as an input for XML input stage in a parallel job. If it can be done,please enlighten me.

WoMaWil wrote:sun, you have posted in the wrong Forum. Here is the Server-one.

In server you can do it.

sorry for the inconvinience bro.

Can I use a sequential file as an input for XML input stage in a parallel job.
If it can be done,please enlighten me.