DSXchange

If inlink.colname <> Oconv(inlink.colname,"MCP") Then you have a non-printing character Else you don't have a non-printing character It worked thanks, I am almost there. At the end of this validation i have to generate a report saying this many control char were founds and these many reco...

No, it should be there automatically. In the Repository browser (tree view) open the Parallel branch. Under there you should see a Processing category. Expand that and you should find it. Thank i did get it Thanks a lot One last thing is thier a Possibility that i can check wether i have a non-prin...

Preprocessing the file with the stream editor sed is probably the most efficient way to accomplish removal of non-printing characters. Within a BASIC Transformer stage you could take advantage of Oconv() with the "MCP" conversion specification, which converts non-printing characters to pe...

I have a set of validation to be performed on a sequential file. Among which one of them is a removing of control characters i.e non-printable char. Here is what i am trying to do. stage1----->Transformation--------->stage2 SeqFile SeqFile in the Columns i just specify a single column of type varcha...

Hi folks In my transformation i have a field which has to checked for nulls. Something like this if DSLink.field=null then ' ' else DSLink.field When i use this it gives me an error. So i tried this if TRIM(DSLink.field)='' then ' ' else DSLink.field but what will happen for TRIM(null) what will TRI...

Thank You so much Kenneth
I will look into those books you suggested. Mean while as u said i will try to do my cleanings process on the flat file itself and then load into teradata using some multi load process.

Kenneth i need a suggestion from you. What if i load the sequentail file into UniVers table (DATASTAGE DBMS). That way i will have the querying capabilities on the data and then i can put the clean data into tera data One more thing Kenneth Do i have to go through ODBC only to connect to TERADATA or...

Hi all, I have a flat file of fix lenth. I have to do couple of valiation and insert that into teradata or again flat file. Basically i have to do some clenansing work on the data. 1. If the record lenth should be 63 or 65 others are rejected 2. Check for not null 3. No duplicate records(Applying th...

Universe tables are something totally different, they refer to a code branch of the DBMS product on which DataStage Server is written. Thanks Kenneth I appreciate it man, now i clearly understood it. So to import teradata tables i have to have a DSN entry right. Once i have it i can associate it to...

nrevezzo wrote:I've successfully used the PlugIn Import feature from Designer to import a Teradata table definition.

Hi nrevezzo
Can you please elaborate it .
Like can give me the steps to do it using the designer

I have to trasfer the data from a squential file to teradata tables. To do so i need the table defination to be imported into the repositry from the teradata table were i want the data to be loaded Can any one help me on this Thanks in advance Thanks Kenneth I was wondering if it possible to import...

I have to trasfer the data from a squential file to teradata tables. To do so i need the table defination to be imported into the repositry from the teradata table were i want the data to be loaded
Can any one help me on this
Thanks in advance