DSXchange

Hi, What is your input field datatype. As Arnd suggested, u have to convert them to char type(If they are not char data type) before concatenating . Once u concatenated, u can convert to whatever data type you have in the target Rgds, Rao. Hi, I am new to Datastage. I have an issue. It would be grea...

Usha: Can u give more details about file content ie. all are having same xml type or different xml schema. I think, when all are having different schema definition, u better to go for JOINER or MERGE. Rgds, Rao. Hello all, What stage is best to use, for joining or add multiple xml files into a singl...

Hi SomaRaj, First you have to convert char date to date data type then use DateFromDaysSince, U will get the result. Ex: DateFromDaysSince(-1, StringToDate("YourdateValue","%yyyy%mm%dd")) Rgds, Rao. Hi ray, Thanks for reply. My requirement is I have a date with sql type char '198...

Ray: I struck while reading xml file in PX. Here i am using "xml input" to read data from xml file. when i try to use it is saying "XML_Input_25,0: Error: 1 input link(s) minimum required. 0 found" When we don't have stage like folder(server job), which stage do we need to use to...

Hi, With my limited knowledge on Datastage, I am not sure whether u can use "Tail stage" which they provided unsder development/debug. Thx, Rao. Hi, How to skip the trailer record which has a different layout from the detail record. File is in ebcidic format. How can we do this with out an...

Hi, If u want handle nulls and assign default value, go for NullToValue function. If u want to assign null value to target column, u dont need to handle at all in px. Thx, Rao. Ok, as a newbee I have a question about this null handling. I was not doing anything on null handling and the job started t...

Djoni,

It uses the universe in 7.5. In the next release Hawk, u can decide on which database you want to store your metadata.

Thx,
Rao.

djoni wrote:I understand 7.5 no longer uses Universe to store metadata. Where does Datastage store its metadata? What format? (RDBMS, file)
Thanks, djoni

HI, U dont require any other stage other than transformer. U only require target to have 2 columns to store the value 1 and value 2. Thx, Rao. Hi All, My requirement is this. Split a column value , value1.value2, to two separate columns containing value1 and value2. e.x. Input col1=1234.5678 --> Out...