DSXchange

Hi DSguru,


I tried with the code you have mentioned. But no luck, all records are going to StagVar = "B" link and no records or 0 records are going through the StagVar = "A" constraint link




Thanks,
SomaRaju.

Hi Dsguru, In sequential file Iam seeing the decimal value as 1234567891.00 for decimal (12,2) and for Decimal (15,2) Iam seeing as 1234567891234.00 and I tried with Length function but it is giving length to all the fields as 15 whether it is(12,2) or (15,2). I mentioned in input Sequential File a ...

Hi DSguru, I tried with Stage Variable as you mentioned. I gave stage Variable name as StagVar and in derivation I mentioned as If Frm_Sort.Price Matches "12N.2N" then "A" else "B" and in Constraints I mentioned as you said StgVar = "A" and StgVar = "B&qu...

Hi Ray, If I use a parallel job and IsValid() function . Can you please tell me what arguments do I need to pass in IsValid() function. I tried like this IsValid("decimal", Incolumn.price) but every record is going to that link . I want to filter records whose length is (12,2) to a file . ...

Hi Dsguru, I tried with the option matches that you have mentioned. But Iam not able to filter any records with decimal length(12,2) . In Stage variable I mentioned Stage 1 as variable and in Derivation I mentioned if Frm_Sort.Price Matches "12N.2N" then "A" else "B" An...

Hi, I have a server job. I am having a field "Price" which has decimal (15,2) length and I want to send the records which has decimal(12,2) length to one file and remaining records which is not having length decimal (12,2) to the other file or link. Can some one help in solving my problem....

Hi Ray,


Thanks for solving my problem.






Regards,
SomaRaju

Hi , I have a job in which Iam doing a lookup to a db2 table directly with out out using any hash files for a column Annd and when Iam doing that Iam getting an warning. Preprocessor_CheckAnnouncement..Xfom_ANNDoc: Reference lookup generated 9555 rows. Only the last row was used. I tried in select s...

Hi us1alslam1us,

Thanks for solving my problem.








Thanks,
Somaraju.

Hi DSguru,

Iam geting the same error and records are going to other/log condition and the error Iam getting after using %yyy-%mm-%dd format is

Error

APT_CombinedOperatorController,0: The schema type "date" does not take parameters "%yyy-%mm-%dd"


Thanks,
somaraju

Hi,


Iam getting the same varchar as the input.





Thanks,
Raju

Hi , while I am using this function StringToDate(in.date, "%yyyy-%mm-%dd") in the target flat file I mentioned the datatype as Date and length as 10 and when I ran the job it is showing that records are processed and when I open the file with view tab it is giving the following warning <Se...

Hi, I have a job and Iam using a transformer stage and Remove duplicates stage in the job and using Hash partition to partition on key1. When Iam running the job it is giving an warning saying Transformer_3: Input dataset 0 has a partitioning method other than entire specified; disabling memory shar...

Hi,


Thanks for solving my problem






Somu

Hi, I have defined a stage variable Region and it is char and length 20 and in derivation section I defined as IF src.country = 'IN' then 'ASIA' Else if src.country = 'GE' then 'EUROPE' Else if src.country = 'US' then 'North America' Else 'Dummy' and source country column is char(30) But Iam getting...