DSXchange

Hi Folks, I have a requirement to get the Job logs before compilation. For Ex : Some unknown person changed something in my code and he simply saved that job and he didn't comile that Job. In my next run when i compile the same job i am getting the modifications which are not done by me.So, my quest...

Hi, In such type of cases you have to set the option in the aggregator Default to decimal output as [30,2], then you can get your expected result. The default value for Default to decimal output is [8,2]. So, change the settings in the above mentioned option. I think this will solve your problem. Th...

Hi All, I tried to remove the Leading spaces from the string by using the following function: Empname= string_trim[" ", begin](Empname) I succeeded by trimming Leading spaces. But i failed to remove tariler spaces by using following function : Empname= string_trim[" ", end](Empna...

Hi Arnd & ray,

Thanks a ton for your inputs.

I dont have huge data to test, that is the reason i posted the query here.

Thanks for your statistics.

Thanks and Regards,
Nagesh.

Hi All, Even i faced the same problem with my jobs sometime back. The main reason behind this is your job is running internally in the server.This is due to you forcefully close your job ( by using alt+ctrl+del in windows) or some other reason. The solution for this is kill your job by using Kill co...

Hi Folks, I have a requirement to create a new column called Empno and populate the Empno with parameter EMPNO_INT_PARM. Now, I have two options to create the Empno 1) Use the Transformer to create the column and populate with vale 2) Use Column generator stage and create new column and generate wit...

Hi Arnd, Thank you for your reply. I tried with the below function and i got the result now. Empname= string_trim['0', begin, end](Empname) Previously I tried with another round means i tried like this Empname= string_trim['0', begin, end](Nagesh) My undersatnding was not proper at that time, now it...

Hi Folks, In One of Ascential Provide Document I read about the following function in the Modify stage : stringField=string_trim[character, direction, justify] (string) In the document they wrote that the above function will trim the Leading or Trailing charcters from the String. But , when i tried ...

Hi Richardan & Kumar,

Thank you for your Inputs. I am selecting the option as dragging the column from Source to Target even though it's a time consuming work to reach better performance.

Regards,
Nagesh

Hi All, I have a requirement to add a column called Analog to the job flow, in this process i have two options 1) The source dataset is coming from another job which have column Analog and add the column in the input dataset and dragg the column up to the Target satge through the flow. 2) I can able...

Hi Arnd, Thanks for your reply.My main concern & understanding regarding shared container performance is, if you use a shared container in 4 jobs it will use same processor, that will save our space( Like combinability mode in each stage).Please, correct me if it is wrong ? Regards Nagesh.

Hi all, I Created a Parallel Conatiner with the content of 4 lookups in the container and i am using this container in 4 of my jobs. There are no dependecies in my 4 jobs. I am running these jobs through Sequence. So, my questions is when i tried to use shared container parallely in 4 jobs, whether ...

Hi , This error may cause of, you are dropping the column in the source side of Merge Stage and you are not carrying to the target. u can remove this warning by two process: 1) If u r not required the column in the output drop that column by using Modify Stage. 2)Other way, u can Disable the RCP(Run...

Hi,

The function for converting int16 to string as follows :

NewColumn:int 16 = lookup_int16_from_string(Old Column:String)

In case of remaining Integer type the convesrion from string to integer would be default i.e. No function required to convert String to Integer.

Regards
Nagesh.

Hi Ray & Bindu,

Thanks for u r response.It is very helpful to me.

Thanks & Regards
Nagesh.