DSXchange

Hi craig, I did a search on "scientific notation" but couldnt able to find a solution. One solution i have in my mind is for example if i am getting the value as 7.61778e+06 then i can take the number before 'e' and multiply by 10 and the number after + which is '6' i.e 7.61778*10*06. Can ...

Hi, I am trying to generate a unique sequence number and appending that value to a string and the data type of that column is varchar. For example the value would be 'ABC_123', but for my scenario the value is populating as 'abc_7.61778e+06' instead of 'abc_7617780' Can you please help me to get the...

Hi ,

When i do wc -l filename i got the value as 3028799 .

Even though if i use a reject link for the Sequential stage , the job is getting Aborted.

Is there any possible solution to reject that record instead of Aborting the job?

Hi craig,

I mentioned record delimeter as Unix new line and ran the job but still got aborted

The only way i could able to resolve is seperated the links for Update and Insert instead of using upsert.

Hi, When i try to run the job i am getting the error as "Consumed more than 100000 bytes looking for record delimiter; aborting". Source is Sequential File and the Final Delimiter : End , Field Delimiter:comma , Null Field Value:" and Quote: double. I have created a user defined varia...

Is there any possibility to avoid that error by using any settings in teradata connector stage?

The job got Aborted due to below error in Log

Activity count zero for Stream Operator update or delete. (CC_TeraAdapter::selectStreamErrorTable1, file CC_TeraAdapter.cpp, line 7,599)

Can any one please let me know the solution for the above issue.

Hi , My target(Teradata) is Upsert and Access Method is Bulk and Load Type is Stream My Source is Teradata and the lookup is a file . When i try to trunctae the target table and run the job. I am getting the error as "[IIS-CONN-TERA-005003] RDBMS code 9903: Activity count zero for Stream Operat...

I have provided the condition If (ISNULL(DSLink18.sourcerow) Or DSLink18.sourcerow='') Then 1 Else DSLink18.sourcerow
but still getting the below error


Transformer_40,0: Field 'sourcerow' from input dataset '0' is NULL. Record dropped.

Ravi.K wrote:Display for us how you are handled Null.

IF ISNULL(DSLink18.copysno) THEN NULLTOVALUE(DSLink18.copysno,1) ELSE DSLink18.copysno or if DSLink18.copysno='' then '1' else DSLink18.copysno

I disabled operator combination.I got the below error. Transformer_40,0: Field 'sourcerow' from input dataset '0' is NULL. Record dropped. I am getting the error in the transformer , but i tried using Null handling functions but still getting the error. Any help is really appreciated. Thanks in adva...

soumya5891 wrote:Is the field on which you are checking null is varchar ?

Yes. I checked with Datatype "Double" also.

Hi, I am having a small job where i am having Null values which is passed through Transformer and then to Sequential file.I have handled Null values in the stage variables in transformer like IsNUll(Column),NullTOValue(),NullTOZero(),Column='', but still getting the below error. "APT_CombinedOp...