DSXchange

Hi ray, I actually tested by handling the Nulls by replacing them by 0's and by defining the Nullability of the target fields both by 'Yes' and 'No'. There was no diference in the outputs/aggregation outputs. I have set the aggregator's NULL output property - 'True' and 'False' when the target field...

Hi, In our Oracle tables all the fields are defined as Nullable. So, in this case if i do Null handling(If Not null Then '0') and if still i define Nullablity as 'Yes' while passing to the target; will this be effecting anywhere specifically if some of these fields are passed to the aggregator for c...

Ooops!! That was a just a typo.

Hi Shilpa,

Just try by casting the fields from the source itself.
Eg: in the sql use CAST(INVOICE_QUANTITY as date), CAST(AMOUNT as decimal(31,11)).
Then in the datastage job use datatypes as date, decimal(31,11) respectively.

It will work if you don't have any issues in modifying the sql.

If you have 3 different links, add dummy fields with values eg: 1,2,3 in each of the transformers header, detail,trailer respectively... then while linking this 3 links to funnel use this dummy field(common to all the 3 links) as sort field. Then header will comes first, then detial racords and then...

Hi, Though my problem is common, i could not make out where my error is. while i am compiling a job it is throwing me the below error from the transformer stage. Also, i just wanted to know how can we find out the error from the compilation log ? Output from transformer compilation follows: ##I TFCN...

'Dsxchange' itself is a huge database. This is discussed many times here.
Lets make a search!!!

Hi Havoc, I've tried this but warning was- Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,0]": Possible precision limitation. I don't understand why it is showing "conversion from decimal(38,10)" .In the oracle database which is our sor...

Thanks all. DSguru, The query is working fine in the sql tools(toad and sql navigator). chulett, Do you mean that pre CASTed sql in oracle stage will not be recognised by the job? Matthieu, I tried this but no luck.I got the below warning- Column <col> floating point decimal is not fully supported; ...

Hi Sainath, Thanks for the reply! I am CASTing the datatype of fileds in the user defined sql of oracle stage. Then passing the fields further by maintaining the target datatype as Decimal(31,11) as i did it in the sql. The target fields datatype/length is same as what is used while Casting the fiel...

Hi, I am pulling data from oracle database.Some of the fields are of NUMBER datatypes in which the data is actually decimal values. In the user defined SQL (of oracle stage),i have casted these fields to NUMBER(p,s) datatype. Eg: From database 'col' is NUMBER I'm changing it to -- (CAST(col as NUMBE...

One option is- Trailer record count: Create dummy column along with your target fields derivations. Take an aggregator and take this dummy column as an input.In the aggregator select the 'aggregation type' as 'Count Rows' and give this column as an input to this and pass the output to the target. Eg...

vsripuram,

Are you pulling data from a database and loading into a sequential file?
And do you want this header and detail count in the target sequential file?

Hi, I am designing a job which is pulling data from the oracle database.The sql used for this has 2 UNIONs with 2 oracle views(sometimes more thatn 2). So, usage of 2 Oracle stages in the design will be any adavantageous in terms of performance while extracting? There are no partitions created for t...

Hi, I have a field CAL_DT from the oracle database which is of data type 'Timestamp' and is a nullable field.In the transformer i am handling nulls of this field in the following way- (If IsNotNull(Check.CAL_DT) Then DateToString(TimestampToDate(Check.CAL_DT),"%yyyy%mm%dd") Else ''. The ta...