DSXchange

Thanks for your reply....
I'm using Teradata Database as source and target..we using UTF-8 for teradata.We triggering errors from Indian Character set.....

Hi All, I'm getting the below FATAL error when i run the job in DS. RDBMS Code:5356 One of the characters or code point does not exist within the specified repertoire. I have been using otranlsate function to search control characters(non printable characters) in custom query. Can somebody explain a...

Thanks for your reply. First Exp:- regexp_replace(column_name,'[0-9\.\+\-]',' ') I have a source column with varchar(10) will be loading to target as varchar(1) by performing the exp. Example:- SRC DATA-123456789A/+A+24+-353/A+234+45- TGT DATA SHOULD-A(I will be using trim to remove spaces) I need t...

Hi All, How to perform Regular Expressions in Datastage?? Below are the few requirements using regexp: regexp_replace(column_name,'[0-9\.\+\-]',' ').. regexp_replace(column_name,'[[:cntrl:]]','|')... I have little knowledge to use by Custom queries..... But how in datastage??Is there any function or...

Thanks Ray....i got it....

Hi All, I have nine output links from Filter as reference to lookup stage.I have 2 records from link one to nine.I have a master file which has 400 records is looked up with key column from reference.I gave Continue in Lookup Failure Condition.I got master records to output,but the link details afte...

Thanks Sura for ur suggestions...

I resolved it.In Teradata Connector Stage,their is a property called->Describe Strings In Bytes..Default is No,but i set it to Yes...After i changed to No,it got corrected and no warnings on that checking operator...

[/quote] Check the above warning you got! You have a field called PGM_ID. what is the Datatype and length of that column in your input stream. Check the PGM_ID in you target table and find the Datatype and length. Compare it.[/quote] In both,source and target the length is char 8 for the column PGM_...

SURA wrote:Warning is very straight forwar. What help you need? You are trying to pass the length of 16 to length of 8.

Either you change the target length / source length.

I'm trying to pass the src value (8) to tgt value (8)...I'm not at all using that length(16)...

Hi All, I am getting the below following warning... PGM: When checking operator: When binding output interface field "PGM_ID" to field "PGM_ID": Implicit conversion from source type "ustring[16]" to result type "ustring[8]": Source string will be truncated. It...

Hi, when i implement the following oracle function in DS Transformer level i am getting the following error message. the oracle function is ----period||trim(to_char(week_in_mn,'0')) . here the datatype of period ,week_in_mn is decimal and double respectively. the target column name is PRD_WK_IN_MO a...

Hi,

I want to implement the following function --- period||trim(to_char(week_in_mn,'0')) in the Ds Transformer.can u give an idea


Thanks,
Venky

Hi All, I'm new to Datastage 8.5 What is the major difference between Export with executables(where applicable),Export without executables and Export executables without design? I have tried with export with executables and without executables...i not tried w/o design option...but i didn't imported ...

Hi, If the key column in the datstage can be nullable, then what does it actually represents??? Whether it specifies only uniqueness of the particular column,irrespective of the nullabality of the column????? So if it represents only uniqueness, then it is the unique key representation and not the p...

Hi ALL,

Can any one give a brief/basic information/link with an clear example for the above mentioned stages...I am new to the Realtime stages....particular with XML Stages.