DSXchange

Hi, In my job i have to count the no. of records coming from the input and i have to carry that to the transformer for some formatting.Along with that count , i have to carry one column from the source to the same transformer. For this i am using an aggregator to count the total rows and keeping tha...

Hi, We are running parallel jobs taking our source from DB2...where i have a DB2 query in which we have 5 orderby ascending columns.In which first two are coming with 'Char' as data type, second column is of 'Date' data type and the other two(4th and 5th) are of data type 'Integer'.Our target is of ...

Hi aparaman, Yup!! This problem comes while you are compling only...I completely...But i got this ("checking composite operator error") error previously and i made a lot of checkings all over my job...But finally it has been rectified only after i have changed the checking method on the Jo...

Hi neeraj, This problem is really because of the job parameters....This kind of problem occurs when you use the job parameters for checking for something..For eg if you give the following expression: If IsNotNull(<JobParameter>) then <something> Else <something> Tell me if really solved your problem...

Hi ray, i understood what you have written..But i believe these convert,Trim functions can be used only when we are very much sure about which characters are coming along with the source....But here in my requirement i am not sure about them...they can be either one of these like... " , - , _ ,...

Hi kumar , Your approach was good...As you said the convert function can be useful only when you are sure which string character is coming along with the numerical value from the source....But, my requirement is take only the numerical value from the source by removing string characters if any..And ...

hi, I have a requirement to pass the source data which may contain some text characters (like quotes), to the target column removing them.I mean i need only the numeric characters in my target. Source is of data type Decimal and target datatype is varchar. For example:- Eg1:- ToNumber("123.45&q...

Hi all, I was using rowgenerator for generating some test data.So i was generating 100 rows with two columns..col1,col2.where col1 is of datatype integer and nullable.So,while editing the col1 and giving options Percent Null as 10..i believe it should return 10% of the output data as null values..bu...

Hi Srikanth,

I got the expected result...thanx for that..

Hi, In the modify stage when i am handling the null value for a date column, for the following expression MKTPRC_DATE=NullToValue(MKTPRC_DATE,'2222-12-12') i was getting the following error-- main_program: Errpr passing modify adapter: Error in binding : Unknown conversion : NullToValue Expected des...

hi ray.wurlod, Your case works when you specify 'Same' as the partitioning method. Does it mean that if two records with the same key column value comes from the source,remove duplicate stage will take the first one and if any further repitition of the same key value ,it will just ignore it...??This...

Hi, "same'' type of partitioning means i believe..it performs no repartitioning.and since i am using a sequential file as my source i will not run parallely. (i am using seq file-->remov duplicate-->seq file) for Eg: my input data from seq file is 5,gun1 2,how 2,how1 4,you 4,you1 1,hi 3,are 3,a...

Hi all, My requirement was to remove the duplicate records from the source(Sequential file).So i was taking a sequential file-->Remove duplicate stage-->sequential file. There are two columns say col1,col2.I gave duplicate to retain option as --'first'. When i gave partition type option as 'same', t...

Hi Arnd,

I didnt get any error while using the dataset management utility.Is it like this utility will not remove all the files related to that paticular dataset...??

I didnt try out with orchadmin rm {dataset.ds}"? ..neway i will try with that..

Hi DsPandits, I was trying to remove the files created by using the datasets using the dataset management utility.But the mail control file is removed ,but the other files which are created along with it are not being removed. We are running our parallel jobs in 4 nodes..So,for each node 3 files are...