DSXchange

Hi, My column definition in Oracle is Number (30,24) as we need accuracy upto 24 decimal places. Using Upsert method in DS to insert rows but it trunactes beyond 10 if we use Decimal data type and truncates beyond 17 if I use Double. Checked using a Peek stage and it does the same, that is, DS trunc...

ray.wurlod wrote:You have to design that in. The output link can receive columns whose values are column names (as constant strings) from the input link.

Thanks Ray, for your suggestion.
Can you please more elaborate? I am sorry. Is there any option to select or check?


Thanks

Hi, All, As part of Exceptional handling requirement; we have to collect column Name from which Data is getting Reject. For Ex. One rule to reject data and Raise an exceptional is: If string values are getting in Numeric Column then that Data has to be rejected and Column Name which Rejects that dat...

ArndW wrote:Are you using RCP (runtime column propagation) for this stage and any predecessors?

No. I am not using RCP for this stage

Hi All, I am getting warning specified below. LKP_PASSETID: When checking operator: The view adapter has a binding for the non-existent destination field "Code_Name". But here in design we dont have any colum like "Code_Name". Could anyone help me on this why i am getting this is...

chulett wrote: Does it always take that long?

Yes

I have a job which has 1 PX Transformer. Sequential file Stage ---> Tranformer ---> Oracle Stage Total no. of columns: 390 Out of which around 150 columns has DataType conversion logic (string to Decimal) and out of 150 columns around 20 of them has "If then Else" logic (1 each). Job is ta...

swades wrote:It looks like, in that cases- at point,TIMEDATE matches with TimeOutSession, the execution point at sleep(5) ,so there were never timeout.

So what should i keep for this Interval

ray.wurlod wrote:What is the problem with this code? What assistance are you seeking?

The Problem is, in some cases Jobs hanging (at Routine Activity) - its not making timeout, if file is not there. So what is there in code, to be corrected.

ray.wurlod wrote:Use the formatting tool in the code editor to make the End statements' dependencies easier to see.

Ray, I have corrected in original Post.Now how it looks like?
I have also added "File Lock check".

Is there any default value of these variables???

Hi, I am getting issue with the date column. Could anyone please help me on this. The End date and Begin date which are getting from the table with datatype Timestamp. Here in table we have NULL records for End Date. We are taking these records into the transformer and doing some validations. The is...

Thanks ray for your reply.I will try that out.

Hi dsxians,

Do I need to set any environment variable to view the set of extended property values?


Thanks
tom

Hi

Please suggesst how to get the month end date for particular date. Is there any function available for this.


Eg: Suppose I have a date like 2000-07-01,
For the above date i nedd the output as 2000-07-31


If anyone have idea on this help me.


Thanks
Vijay