DSXchange

Hi,

I am getting the following error while loading the data into Oracle.

Oracle_Enterprise_29: When checking operator: When validating export schema: At field "LEDATE": "null_field" length (10) must match field's fixed width (8)

can any one help me asap.

Thanks,
sudhakar

Hi, I am getting the following errors. Lookup_21,0: Ignoring duplicate entry at table record 2; no further warnings will be issued for this table Lookup_21,1: Failed a keylookup for record. Lookup_21,1: The runLocally() of the operator failed. Lookup_21,1: Input 0 consumed 1 records. Input 1 consume...

Hi,

I am popilating the data from sequentialfile to DRDBMS(oracle).I am getting the following error.
Dynamic_RDBMS_57,0: Invalid timestamp value in getInputFieldAsString()for field '9' of input dataset '0'.Give me solution for this


Thanks,
sudhakar

Hi,

It is having same data type.

Thanks,
sudhakar

Hi, I am getting the following warning while exporting data into sequential file. I am taking the data from sequential file and dataset and then i am doing join then i am populating data into sequntial file. Warning:- Sequential_File_8: When checking operator: When validating export schema: At field...

Hi, I am getting this error while i am using oracle as a lookup. Oracle_Enterprise_10: When checking operator: When binding output interface field "MRATE" to field "MRATE": Implicit conversion from source type "dfloat" to result type "sfloat": Possible range/p...

Hi loveojha2,

It will give the row by row.I need the total count and i have to store the count in database table.

Thanks,
sudhakar

Hi,

can i get the just count in the same job

Thanks,
sudhakar

Hi kollurianu,

Your date format is 2005-10-19 11:21:38.0.

Observe once this format.It contains 0 as extra at the end.Thats why it could not able to convert.So,you have to apply the substrings command
also.

Thanks,
sudhakar

Hi,

I searched for XMLPACK_20_Designer.pdf but i could not found the XMLPACK_20_Designer.pdf,So, From where can i get the XMLPACK_20_Designer.pdf file.

Thanks,
sudhakar

Hi DSGuru,

Thanks a lot.And one more thing,if we are using hashed file how can get the count.

Thanks,
sudhakar

Hi DSGuru,

Thanks for your replying.My reqirement is to do everything in one job.And one more thing is i have to update the database.How can i apply wc -l in the same job.

Thanks,
regards,

Hi DSGuru,

For each record it will give the @OUTROWNUM.How can i get the last record @OUTROWNUM.If you use the stage variable you can store the @OUTROWNUM.How can i store this information in database

Thanks,
sudhakar

Hi DSguru,

I don't want to use the aggregator.Thats why how can i achieve

Thanks,
sudhakar

Hi chulett,

i did not specify any XPath.i have taken one sequential file and one transformer and one XMLOutpu.And then i just drag the columns in transformer.I specified the path where this xml has to be created.What else i need to do.

Thanks,
sudhakar