DSXchange

Now i decided to read whole data in a single field and carrying out the further transformations.But now encountered with another warning message as : Missing record delimiter "\n", saw EOF instead My file has no Record End Delimiter,and contains ony a single record. so what should i do to ...

Maveric, Its not really a direct load,i am doing pivoting after extracting the data from the file.so i cant go ahead without mentionig the metadata.I know we can handle it very easily in server jobs but not exactly in parallel extender.Is anything i can do with format,i dont have any delimiter as En...

Hi all, i have job which reads the sequential file and writes data to the oracle Database.metadata for the sequential stage holds nearly 50 columns but i may get only 30 columns from another file,which i need to load it from the same job.so my question is like is their any option in parallel extende...

project's Environment Variables are identical for both the old and new environments. And both servers using the same OS (ie.Sunsolaris) also.

Hi all,
Anybody has faced this kind of problem before, If so please share the solution.

Thank you........

Its not all about licencing & PWD settings in it.everything is assigned and its a licenced one.Its just simply throwing the error like that,thats it.

Oh... sorry about that. Actual error is; ##I TUTL 000031 01:48:57(001) <main_program> The open files limit is 100; raising to 65536. ##I TOSH 000002 01:48:57(002) <main_program> orchgeneral: loaded ##I TOSH 000002 01:48:58(000) <main_program> orchsort: loaded ##I TOSH 000002 01:48:58(001) <main_prog...

Hi all, I have nearly 6 parallel jobs which are recently moved from development environment to Test Environment. all the jobs are working fine development environment, but in test i am unable to compile the jobs.when i try to compile the jobs i encountered with the following errors: 0211: if (null(L...

Hi Ray,

Thanks for your reply. You mean then there is no way to handle such datatype in PX. Everyting we need to do manually? Any reason why it's there in server but not in PX.

Thanks,
Aquilis

Hi All, We are migrating from Ab Initio to DataStage PX 7.5.2. We are reading from and writing into the plain text ascii files. In Ab Initio there is option known as implied and explicit decimal. I am looking for similar options in DS as that of in Abi so as to avoid complex work around and which ma...

stefan, I worked out.According to your suggestion i have tranformed decimal to string then applied trim,it worked out. I used function as: Trim(Decimaltostring(Column_name,Fixzero,suppress_zero),"0","L").. But one thing i didn't get that below functions works well even when we do...

Hi all, I have the Decimal(38,10) data an i am loading it to the another DB table as a Vatchar2(25). when i run the job data gets loaded with the added leading zeros. If data is '6.50',then......'000000000000000000000006'(23zeros) For 57.98............'0000000000000000000000057'(22 zeros) if data is...

My source datatype is Varchar2(10).I may get any value either its exact correct date format value or any charcated/flag/dirty value in this column.So only i am validating the values with date fromat('YYYYMMDD').If its doesn't matches with the format so it should reject.Thats why i am using that vali...

Maveric, i am getting error message as : "ORAcode -01830: date format picture ends before converting entire input string" its oracle error message,i am using userdefined Sql query to load the adta into oracle DB.In between at transformer i am using that above mentioned function. If (IsVali...

I am using IsValid Function for date validation, as in: If (IsValid('Date', StringToDate(LNK_Read_Input.UPD_TS,"%yyyy%mm%dd"))=0) Then 'N' Else 'Y' Doing this in Stagevariable1. And mentioned main constarint as Stagevariable='Y'. whenever i encounter with the invalid data like '20070627 0'...