DSXchange

But if I am running the same job more than once, it will throw an error saying that the .ds file already exists. How do I give the option of Overwrite as well? The job will always be run twice (minimum).

Hi, I want to load a Dataset Target File, but it always throws the warning XYZ.ds file empty. In the first load it will be empty right? I have created an empty file in UNIX and given Update='Overwrite' in the Dataset. I have three dataset files as target. The error is coming only for two .ds files. ...

I did not want to use unicode anywhere so I removed it while importing itself. But this particular column still showed Varchar(Unicode) as its SQL type. Hence, I manually removed it. None of the columns have unicode now. In the source(SQL Server) the datatype is 'Nvarchar'. The datatype and length g...

Is there any solution for the alert messages to stop coming?

I have given Varchar + Unicode. No difference at all.

Hi All, Sorry for re-opening this topic. I am getting these warnings: When checking operator: When binding output interface field "AR_ADDRESS3" to field "AR_ADDRESS3": Implicit conversion from source type "ustring[max=50]"to result type "string". When checking...

Thanks a lot guys

Hi All,

I would like to know what is the maximum number of workflows which can be given in a Parallel Job? Is there any limit?

Also, what is the maximum number of target tables we can load in a single job? Is there any limit?

Thanks in advance.

Regards,
Deepa

Thank you. I used 1900-12-12-00:00:00.

I'm sorry for the repetition. This is more specific to DATE fields-Timestamp in particular. I meant instead of giving Null Field value which has 26 characters, is there any other approach? When I use Actual Length and Null Field Length it throws an error saying, it must be used in conjuction with Pr...

Hi All, I am getting this error: SEQL_Current: When checking operator: When validating export schema: At field "system_business_date": "null_field" length (2) must match field's fixed width (26) The datatype is Timestamp. What value do I give for Null Field Value? Currently I hav...

I did do that initially but it threw warnings saying that Null field length does not match the columns fixed width length. I had given Null Field value as '\xAB' and fixed length of the field as 10.

Its currently throwing these errors: 1)Error when checking operator: Unable to initialize the exporter. or Error when checking operator: Export validation failed. 2)Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length. The first v...

Hi,

How do we define a Fixed Width Format for a Target File?

What all options do we select?

Regards,
Deepa

Hi, I am getting this warning while using the Change Data Capture Stage: CHCP_GL: When checking operator: When binding output schema variable "outputRec": When binding output interface field "source_code" to field "source_code": Implicit conversion from source type &quo...

Hi All, Firstly I would like to thank everyone for their contribution and help. I finally got the solution. PHEW! :) The field delimiter -Quote=double was given. Within the data, in some record or the other, double quotes were present. Due to this, DataStage was rejecting the records. I changed the ...