DSXchange

If you have a transformer used then, Use convert() function to remove these characters. If you cannot then try to find its HEX equivalent and use a routine to remove this from the file.

check to see if the fields you are trying to map have the same structure(metadata).

Hi,

How do I list only the jobs listed in a particular category (folder) within datastage.

:!: You can't be having "the same problem". Please start your own post with the relevant details of your issue. ... Hi Chulett, I am on a Server Edition...and I was browsing out for the error I had...so was curious to know the solution he had..... I have a stored procedure which does not ...

how did you solve this problem as iam facing the same problem now...

Check again, it seems to be telling you that your maximum value is in fact 100000000000000000, if that's what you found in your log. ... Hi chulett, The maximum value from the source is 9999999999999999( 16 digit), but the transformation for some reason tried to get this value on to the ouput 10000...

Hi Ray, The maximum value I have is 9999999999999999( 16 digit), and the output value as per my condition should have been 9999999999999999.1 (16 nine's and a 1 preceded with a decimal). The output format is (Numeric 17,1 ). Everything seems appropriate, why should my output generate 100000000000000...

In Server jobs how should I convert a Numeric Value to a String Value.

The values of indv_id, I find in the log is as follows 100000000000000000 (17 zeroes)

Hi I have two fields that are coming from source clmnt_id (Numeric 16) and indv_id (Numeric 10). The source is Oracle DB. I am taking indv_id (Numeric 17,1) as the output based on the following condition below If (IsNull(out_t6xfrmOPTNTEVNTFACT.indv_id) or out_t6xfrmOPTNTEVNTFACT.indv_id = 0) then (...

You do realize, do you not, that you just repeated yourself without explaining anything or answering any of the questions asked, yes? :? Hi Chulett, Sorry for not explaining in detail. I have the delimited list of data upon which I am making the loop. This is implemented for the historical load. Go...

So, you need to run this query 39 times, once for each Y/M combination going back that far, right? Sounds like you may already have a looping Sequence in place and just need a delimited list for use in the Start Loop stage? Or do you actually need something else? I need the logic..of how to get the...

So, you need to do this in a SQL query? And you need all data in this date range or you need a list of the Year/Month values between them? Examples would be nice, btw. ... I have a query which is within a query as below SELECT ief.frst_srvc_day,ief.erlst_process_day FROM #SrcSchema#.inpatient_event...

Hi, I have one of the source field coming as an year month ( eg. 200909). The requirement for me is to pass this as parameter to one of my query in the loop and get all the values of this month and all the 39 months prior to this month. How should i approach to get the difference in year months value.

Hi All, I have two files that in the range of 3 GB to 5 GB. We have used hash files for having the facts implemented. The performance of job is really slow. I know that we have the limitation of 2.2 GB on a hash file. What are the things that I can do apart from a hash file that can really help in i...