DSXchange

Hello Gurus, How can we implement "while loop" logic in the job ? I am familiar with implementing looping in transformer but not quite sure how to go about implementing the looping for the below while loop inside the stored procedure: DECLARE @pnum int SELECT @pnum = 0 DECLARE @vendor_id v...

Yes the Unicode is defined at Project level. My Problem is that I have done the development. I have no prob even if it is there (as Unicode) but just to avoid some warning in Jobs I want to get rid of it in a more efficient way rather then in a hard way of doing it as suggested. I tried it by modif...

anbu wrote:

Code: Select all

Convert(Convert('0123456789','',REFERENCE_NUMBER),'',REFERENCE_NUMBER)

Thanks for the reply. In the above code '0123456789' represents DIGITS and your are suggesting to replace DIGITS(DSLink8.REFERENCE_NUMBER) wit the above code ?

Hi All,


I am trying to find equivalent function for DIGITS function in Parallel jobs. I have the following in the Server job:

link.Column_NUMBER : DIGITS(link.REFERENCE_NUMBER)

Can anyone please post the equivalent function.

Thanks

Message handlers are based on the Message ID. Only that particular message ID will be masked. And only in jobs for which the message handler is loaded. ... Yes true. I am just concern to know whether masking this particular warning will never mask an error so that there will not be a change in the ...

Make sure you check Allow Multiple Instance in Job Parameters.

Hi All,

I have a general question---

We are planning to mask the below warning using Message Handler, I am curious to know if it will mask any error in the future.


cc_stage: When checking operator: Defaulting "X" in transfer from "beforeRec" to "outputRec".

I tried but it didn't work. I handled the warnings using Message Handler.

Hi All, I am getting the following warning, which I think it is a problem with data type. I tried several combinations but it is not working, can someone please tell me the equivalent data type for dfloat ? This warning is from the Aggregator stage where I am trying to get the RowCount. agg_CountofC...

I am getting this warning in Change Capture stage where the 2 input links to the stage differ a bit in the metadata. From Change capture I have a transformer and there are 2 output links.... one link has just one column to count rows using aggregator and other reads into a file with different column...

It is in the Change Capture stage. RCP is not enabled.

Hi

I am getting the following warning, any suggestions on how to remove:

cc_Address: When checking operator: Defaulting "ColumnName" in transfer from "beforeRec" to "outputRec".

ray.wurlod wrote:Take a look at the metadata on both sides of the MatchAddress stage.

A flag never really needs to be bigger than a TinyInt (uint8). ...

Thanks Ray. It worked I changed the SQL type to TinyInt and warnings are gone.

Hi All, I am getting the following warning and finding hard to remove can anyone please guide me to the destiny. MatchAddress: When checking operator: When binding input interface field "qsFreqHeaderFlag" to field "qsFreqHeaderFlag": Implicit conversion from source type "uin...

srinivas.g wrote:In modify stage mentioned like Specification=NOWARN.
It will go automatically no need for message handler.

Thanks for the input srinivas. I tried your approach but the warning got doubled, I mentioned NOWARN in Specification. Please validate my approach..