DSXchange

Hi How do i supply Environment values to Email Notification Sequence in DataStage 7.0. I know that DS7.5 has the option where we can select the values, but in DS7.0 there is no such facility. I want to supply SMTP mail server , Senders Email address and to Recipient Mail address with Environment val...

Hi Check the following link

http://wiki.ittoolbox.com/index.php/Par ... ransformer

Ya I tried the same function that you gave me for the ones coming in with num for the four digit length and I wrote those records to one file. And in the rej file I used Not(Num(input Column(11,4)))function for the records which has charecter in the 4 lengh value ex(12c3). That is working good. Anyh...

Hi, I have a field 'X' varchar(22). I need to use substring function [11,4]. substring function is working. If I have a charecter in the 4 digits value I have to write it to a rej file in the transformer otherwise I need to write the record in the someother file. I tried AlNum function but it is not...

Hi, I have 'X' field in my job it is coming in as a varchar(16) we are converting it as timestamp in the transformer .We don't have any conversion problem. some reason we couldn't load the data into the main table.I Know the problem is with this field only. When I try to load with the current timest...

Hi,

I need a help on writing duplicate records to a file.

I know we have some duplicates in the source file,
when I use remove duplicate stage I found some duplicates are there in the source file.

But my question is there any way we can write those to a file.


Thanks

Never mind everything is Ok.
Later we found that there is a problem with the data.

But anyhow thanks for your response.

Hi, I have a field 'A' coming in from the source as varchar2(16) The values is 200702231233 actually it's a datefield. I need to convert it into timestamp with the fallowing format 2007-02-23 12:33:00 basically when I perform conversion I need to concatenate seconds. I used string to timestamp funct...

If I do that it's showing me a Transformer stage.
Ya that is where I am doing this Char to Decimal function.
But my question is the field is coming in with 10 length and when I
convert it I am giving 18,4 so I am giving more length right?
So how can it say that decimal value is out of range.

Thanks

Hi, My job is like this If the problem is with the decimal fields then I have 2 fields which are coming in as (char) and field length 10 and I am converting it as Decimal in the transformer with the fallowing function and field legths as Decimal(18,4) StringToDecimal(lnktest.field) I have created th...

It is working

Thanks

Hi, I have a field (A) coming in as varchar(22) the data of that field is like this EMP.SALE..1978 the target table has this field as integer (10) I need to strip off 'EMP.SALE' and convert the rest of the number as integer. I need to populate only 1978 What function works for this kind of conversi...

Hi, I have a field (A) coming in as varchar(22) the data of that field is like this EMP.SALE..1978 the target table has this field as integer (10) I need to strip off 'EMP.SALE' and convert the rest of the number as integer. I need to populate only 1978 What function works for this kind of conversio...

Hi, My problem is like this... One of my source fields(A) has a datatype varchar(22). But my target table has that field as Integer(10) when I try to convert it as interger by using the fallowing function AsInteger(lnkdummy.A) in Transformer it is giving Zero's instead of values 1956,1975 etc. Is th...

Hi, Can anybody tell me why I am getting the fallowing error main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel APT_DBExportOperator in oracle_Enterprise_12. The number of partitions is already constrained to 2, but an eSame partition...