DSXchange

Do we have any limitation on writing expressions in Parallel Extender Transformation Stage ,because when i am using 300 colums with same expressions my job is working fine and compliation is also fast but when i am using all 1220 colums in single transformer , its throwing lot of errors (Error when ...

Thanks for your comments , I will try with that option

Hi

I have a simple job which contains input as sequential file (1220 fields) , one transformer (using for cleansing the data ) and i am spliting these 1220 fileds in 4 oracle tables.

But while compilation its talking more that 30min .Please suggest me where could be the problem.

Thanks in advance

conversion of all "." to CHAR(128) - What does it means and how to do it ?

Thanks for your immideate response Is there no any other possible way because my source is having 1220 field out of that 700-800 filed are numeric (where i have to convert dot (.) to oracle NULL )so using modify or transformer stage is tedious process. In Modify stage i can't bring 700-800 fields or...

"I can able to see the Nullable -> Null Filed Value property in Column Edit row

But when i am giving (.) period in that place my output is coming as "NULL " string not as oracle NULL value

I wanst to replace my all (.) period in NULL value "

in server Sequence file stage there is a property called Defaut NULL String , what is same property in Parallel Extender and also incoming data from sequence file is coming with dot (.) i want this should convert into null default , in coming column field is numeric. what could be the possible solut...

Normally you want to avoid plucking env variables from within a routine as it breaks good modular coding practices. Kind of like using global variables in Visual Basic code. The project specific environment variables are set as the default values for job parameters, it is possible that someone will...

Environment variables have to be setup in the job as job parameters. As for getting any variable into a subroutine (I assume you mean before/after transformer/job subroutine call) you have to pass it as the argument. Your subroutine needs to get it from the argument. Otherwise, you will need to do ...

Any body know , how to invoke project variable that is environment variable in subroutine.... i created one variable say Hash_file_location in project level environment variable... i need to invoke this variable in my subroutine. is it possible i know how to invoke this variable from job parameter.....

" Its is not returning Null, it is just telling you the contents of the record keyed by 449100 and since you don't have anything in the record it is telling you nothing. To understand it, use a Hased file which is having columns other than the key column and you will understand what is it doin...

" Its is not returning Null, it is just telling you the contents of the record keyed by 449100 and since you don't have anything in the record it is telling you nothing. To understand it, use a Hased file which is having columns other than the key column and you will understand what is it doing...

chulett wrote:Is your hashed file in an 'account' or is it a 'pathed' hashed file? This utility will only work with account based hashed files, hence the question.

This account based hashed files

Null means it does not exist. What do you want it to do? You can copy this routine and make your own version and return @TRUE if found or @FALSE if not. Hi , AccountTest hash table is having 449100 value., when i run the routine it is saying null....! i am not able to understand... how to pass arg ...

Hi All, when i am calling UtilityHashLookup function in my routine , it alwas return space ... my code is Deffun UtilityHashLookup(A1,A2,A3) Calling "DSX.UTILITYHASHLOOKUP" RowNumber = UtilityHashLookup("AccountTest",449100,0) Ans=RowNumber Account no 449100 is exit in AccountTes...