DSXchange

Hi, Datastage V 8.1 I am trying to generate the sequence number by using database sequence in surrogate key generator. We have given all the details like database name, instance name, id and password. The sequence is not generating it is giving zero or 0. The database value is incrementing but it is...

Hi

I am reading the xml file and storing in to the dataset .suppose if the xml file is not valid file, is there any way to send an intimation like xml file is not valid..

thanks
raj

when i try to read the seqfile i am getting the below warning :

Import consumed only 15bytes of the record's 16 bytes (no further warnings will be generated from this partition)

my seqfile is having just 4 records only.

Could anybody help me....

Hi, I would like to know how to implement the scd type 1 in px. my requirement is as follows source is dataset with three coloumns and 1 coloumn is key coloumn and i am using the lookup stage and my reference stage db2. i am doing the lookup on one key coloumn and i am updating the fields whtever we...

Hi when i try to genarate one sequence number by using surrogate key genarator i am getting the follwing warning. Surrogate_Key_Generator_91: When checking operator: When binding output interface field "key" to field "key": Implicit conversion from source type "uint64" ...

Hi Raju, The Error Log clearly says that you are trying to convert some character value to integer value. This can be identified from "source type string[max=255] to destination type int32"... Try fixing this error by ensuring that both your source and target is having the same data type ...

Hi i read the 2 files in 2 different jobs.now i am trying to lookup one file with other and getting the out ,key i mentioned and datatypes are same for both . when i run the job i am getting the following error : Lookup_0,0: Un-handled conversion error on field "name " from source type &qu...

Please, for goodness sakes, answer my dang questions regarding your job design. If your design is wrong, we could be chasing wild geese that a simple redesign would solve. :evil: Hi The problem is solved . Reason is seq stg is not reading the full xml file properly .so, we used path instaed of xml ...

OK... teeth pulling time... let's start over. :? What does your job design look like now? Did you get rid of the Sequential File stage as noted in the blog entry I linked you to? If not, do so now and then try it again. If it continues to fail, post all of these same details again, down to the sett...

chulett wrote:As noted, at the very least your XML document seems to be invalid. Get a corrected one from the source and try again. Did you open it in IE? ...

Hi
I opend with IE it is opend correctly.

thanks

The first simple test is to make sure you can just open it in IE. Also, it might be a code set issue also [you will need to do some research on the settings that are available in the header of an xml document as to things like UTF-8 or UTF-16, etc.]. Ernie Hi , after running the job i am getting fo...

Hi All I am trying to read the xml file seq-> XMlinput -> dataset seqfile format i have mentioned record type implicit delimeter none. i am getting the error .can any body help what its regarding . XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 15, column...

Hi All,

My source is csc file and i am getting one coloumn is date field and want to load the date field in to the table.Can anyone tell me what function i need to use.
Date format :MM-DD-YY

Thanks in advance..

devesh_ssingh wrote:please refer the link

http://it.toolbox.com/wiki/index.php/Lo ... rallel_job

HI

Thanks for ur information.

without using peek stage can i do like this:

seq -> XMl input -> Transformer -> dataset

is that ok .

correct me if am wrong.

Thanks

Hi all

I want to read one XML and store in dataset.Can any body tell me how t proceed.

Thanks,
rajashekar.