DSXchange

Hi,

I am getting an error "Invalid character value for cast specification" .

Can anyone tell me what would be the exact problem?


Thanks

Hi, You can use stage variables for arrieving this logic svCntType1 => If LNK_Source.ContactType = 'E' Then LNK_Source.ContactDetails Else '' svCntType2 => If LNK_Source.ContactType = 'M' Then LNK_Source.ContactDetails Else '' Place the svCntType1 against the EMail field (target) and svCntType2 agai...

Hi,

I would like to know if there is any function in DataStage to convert from

1. double to decimal
2. double to char

Regards,

Hi,

I would like to know if there is any function to convert from

1. double to decimal
2. double to char

Regards,

Hi,

Source has 'desc1' field that contains 6000 characters (max) and that need to be split into several records of 100 chars each

ex. 1 Record ('desc1' - 720 characters) => 8 Records (7 records with 100 characters each and 8th record will contain 20 characters)

Hi,

Thanks for the reply but my question was whether it will return correct result or not?

Hi,

I have a source S and Hash file H as lookup. Source S is looked up against the Hash based on 5 fields. I need to get the matched records based on the 5 fields from the source. But the data for 2 fields may be null. Will I get wrong result because of null data?

-

Hi,

Indexing will solve to some extend.

-

Hi, I have say 1000 records in the source and when looked up against a hash it matches only 200. Now, I should load 1000 into target instead of 200 Here for one field I get the value from the lookup i.e. 200 records with values for the lookup field from the hash file and for the rest 800 records the...

Hi,

In the Datastage Administrator you can increase the Request Timeout if you have the admin rights

-

Hi, You can avoid duplicate records by following the below steps Sort the records and in the transformer call a routine that contains basic code as below DupFlag="N"; if trim(prNo)=trim(Field1) then DupFlag="Y"; end prNo= Field1; Ans=DupFlag; Filter out DupFlag = "Y" in...

Hi, Try this... m1 ... m12 are the months. In the target add 12 columns additionally like below m1....m12 r1...r12 set r1 = 1 r2 = 2...and so on. Now use pivot stage to transform m1 ... m12 and r1...r12 in to rows like below monthval rowval m1 1 m2 2 m3 3 . . . . Hope this gives you an idea - :lol:

Hi,

You can try this

Ereplace(Oconv(effdate,"DYMD[4,2,2]")," ","-"):Oconv(effdate, "MTHS")

Regards

Hi,

Adding to my previous reply........

While logging to database change the NLS_CHARACTERSET and NLS_CHARACTERSET values in prop$ table to reqd. one

Hi,


You have to specify a valid character set identifier in the OCI call and there is no other option for this.

- ) :