DSXchange

Hi all, I want to know which stage can do this operation faster than the transformer stage: source data: col1 col2 col3 10 abc 12345 10 sdf 45689 20 fgr 78965 10 abc 78962 20 fgr 85623 expected output: col1 col2 col3 10 abc 12345,78962 10 sdf 45689 20 fgr 78965,85623 In my job which gets million of ...

ok thanks for the info Roy.Leaving the space issue aside, atleast from the time consuming perspective, can you advice me an alternative logic or stages to acheive the same functionality?

yes, i am using a remove duplicate stage to remove the duplicates from the sorted and tagged data and passing the last record to the target. I have the file as the source and target, no where i use a database table here. My doubt is - Is there any way i can avoid the load to each stage and so that i...

I have a job which helps me acheiving the following functionality: source: col1 col2 col3 10 aaaa 123 10 aaaa 345 10 wqert 126 10 aaaa 789 output: col1 col2 col3 10 aaaa 123,345,789 10 wqert 126 I have used the sorter to sort the records based on col1 and col2 and in the next stage, transformer, i c...

can I access a particular job in mutiple designers? pls let me know how to do it?

Welcome Aboard It is doing what you asked it to do. Converting it to Decimal(5,1). What is the datatype of this particular column, as defined in your output link. What is your output , is it a flat file or database? thanks for ur reply. this is wat has to be achieved: A column (string 6) wth value ...

hi all,

i get the following warning and the record is also dropped... i would want to know how to avoid this...

APT_CombinedOperatorController,1: Field 'INP_TMP_4' from input dataset '0' is NULL. Record dropped.

This field is a decimal field of length 7 n precision 2

Thanks

Hi Ray,

sorry to say this - i am not able to read ur message completely, as i dont hold the premium membership. can u pls post the reply visible to me? pls

Hi, I have a string field column, which is to be converted into decimal when it is loaded into the xml. Now the problem is- the input string is "00000499" and after i convert that to decimal(7,2), it is loaded with zeros infront of the decimal. pls tell me how to remove the leading zeros? ...

Hi, As i wanted to limit the number of records to be loaded in a job, i used this option - job properties -> exectuion -> force complie here, i faced a problem, all the limited records which are read by the datastage, are being wriiten to the log and so it takes more time and occupies more server sp...

Hi, According to my requirements, I have to use a sequential file with more than 20 Million of records to load a job. I thought instead of using a sequential file directly, if i use a dataset which is loaded by the said sequentila file, and use this dataset in the job, the performance would be bette...

Hi, According to my requirements, I have to use a sequential file with more than 20 Million of records to load a job. I thought instead of using a sequential file directly, if i use a dataset which is loaded by the said sequentila file, and use this dataset in the job, the performance would be bette...

hi all, I have an issue after i convert string to decimal.. this is the derivation for the column which is of decimal 5 as length and precision as 1, "if condtn then (stringtodecimal(column1[4,2])) else null" . i dont understand how i can get a value 0490.0, for the input 000490. It has a ...

hi, I am facing a problem which goes like this - i have some catogories and jobs created inside the repository in Designer, but today i am not able to view either a single catogory or the job in the repository ... I tried viewing the exsistence of the job in the DS_JOBS from administrator and it sho...

I am Sorry Ray, i domt find anythg for transformer stage.