DSXchange

Ok I understood that datastage counts the firstchar from count 1 but it should give only till 14 th character as the derivation is[9,14] but why it is picking till 16th character?

Hi, In the Transformation derivation I taken SourceAccountId[9, 14] derivation. Input data is '123456789ABCDFGHIJKLMNOP' I am getting the out put as 9ABCDFGH Is datastage counts the position of the character from 0 to or 1 Even if the datastage counts the position from 0 it should give the output da...

Hi, In one of the Job, For a particulor column of the type varchar in the dataset is having a value as blank but while loading the teradata the same column defined with the data type decimal. Since it is space/blank at the dataset it is populated as Blank at the teradata. Now again from the teradata...

Try changing the table to "VOC" and do a view data on it? Do you get the same error message or one stating bad column names? Why con't we use the Transformation stage and stage vatriables with logical operators to find out the date range like Actualdate>=rangedate1 and Actualdate<=rangeda...

Try this. "%yyyy%dd%mm". What you are mentioning here is the format of your input. Since there is no "-" in your input data and u have specified it in the format, you were getting this warning. StringToDate(pEFFECTIVE_DATE,"%yyyy%mm%dd"%]) I am using a jobparameter PEF...

Try this. "%yyyy%dd%mm". What you are mentioning here is the format of your input. Since there is no "-" in your input data and u have specified it in the format, you were getting this warning. StringToDate(pEFFECTIVE_DATE,"%yyyy%mm%dd"%]) I am using a jobparameter PEF...

Try this. "%yyyy%dd%mm". What you are mentioning here is the format of your input. Since there is no "-" in your input data and u have specified it in the format, you were getting this warning. StringToDate(pEFFECTIVE_DATE,"%yyyy%mm%dd"%]) I am using a jobparameter PEF...

Maveric wrote:Posting a sample of your input data for this field here would help. Check if the year date and month are actually separated by "-". Also see if the date and month are always 2 characters or digits.

My input data is 20070101 and expected resulut is 2007-01-01


Thanks

Hi I am using the function StringtoDate(Jobparameter,"%yyyy-dd-mm%") But getting warning and no records are populating into the target. APT_CombinedOperatorController,0: Conversion error calling conversion routine date_from_string data may have been lost Peek_12,0: Date:********** Could yo...

ray.wurlod wrote:In your Lookup stage specify the "Lookup Failed" rule as "Fail".

Thanks Ray


Regds

Hi,

I have a job where i need to abort the job if the lookup is failed . how can i achieve this.

Is DSStopJob() function can be used to do so in Parallel jobs?

Regds

Imagine we're processing the date 2007-10-04. The year is 2007, the month is 10, and we require 2071001 as the result. The "2" is the century designator. cast(YR as INTEGER)-1900)*10000 returns (2007-1900) * 10000, or 2070000 cast(Mnth as INTEGER)*100 returns (10 * 100), or 1000 cast('01'...

It's creating a date in %yyyy%mm01 format (the first of the month of the received year and month), as an integer, but with a modified century indicator. Is this, perhaps, intended for a JD Edwards data table? Hi Ray, It's not from the JDE data table. But I didn't understand how exactly it works. Ca...

Hi I has some difficulty in understanding the following statement which was used in one of the Job. YR and MNTH values are paasing from the Teradata operator. cast( (cast(YR as INTEGER)-1900)*10000 +cast(Mnth as INTEGER)*100 +cast('01' as INTEGER) as DATE) Can any body please expain the output of th...

Maveric wrote:Do an exact search on "preserve-partitioning". This has been answered a lot of times here.

Thanks Maveric, Now after setting the clear flag I am not getting any warnings.


Regds