DSXchange

All the fields are of data type are Varchar

Hi All, Well i have this job where i get the sequential file which is created in the server job . this file has delimiter as , and quotes as " on the server side but when i try to view this file in the parallel job with the delimiter as comma and quotes as double i see that few of the fields as...

i tried even that but still doesnt seem to work ...

any other way to handle this?

But the same thing is working in the other job.
as in another job i see the same kind of flow and the link is displaying the exact number of rows.

Where could you think i might have gone wrong ?

Help plz

Thanks in advance

Hi All, Well i have this simple job where i'm using a copy stage . the flow goes this way Seq-> copy->transformer->dataset well the job runs successfully but the output link from the copy stage to transformer shows a 0 rows,0 rows/sec. but at the out put ( ie the link goin to dataset from transforme...

Thanks for the information .

Well then why is that in server jobs i can view the data?

just wanted to know more about it

Thanks in advance

Well i got to know the problem , here the transformer is not functioning properly ie is why that problem , hence i used the basic transformer n tried doin it . well i could load the data n i also see that i row has been loaded into the oracle table but my problem now is i'm not able view the oracle ...

As suggested i converted the field to decimal using the formula StringToDecimal(Trim(DSLink2.BMC_Count, "0","L")) then i tried loading the table but i have errors while compling the job itself. the error is displayed as follows i tried doin this but i got and error while compling...

Hi All, Well i have this job where i need to load the oracle table from a sequential file . the sequential file has two fields which need to be loaded into oracle table . i have an issue i need to load this table in insert/update mode? i wanted to know if this was possible in parallel jobs and if so...

Hi All, Well i have this job where i need to load the file into oracle table . well i have this field which is of type char in the file and is of length 10. this field is holding the count value . i need to get rid of the leading zeros in this field . how do i do this . looks like the fmt function d...

You r right Craig. u r a genius!!!!
and thanks everybody for your patience and help. u guys have been wonderful !!!

i checked even that . i actaully trimmed promoid field in botht the files . but still its showing 0 rows , 0 rows processed. and one more thing which i observed is that one of the field in the refernce stream is appering as null where as it as data in it . well when i check ed the data at the input ...

Hi all, Well i have this simple job where i am suppose to join two files. the files being sq_offerpacking data sq_promodata well i gave the offerpacking data file as main stream to the transformer and promodata i gave it to a hash file and then to transformer as referenece data. well the offerpackin...

No precision is specified for this field..