DSXchange

Ray, y r u so on sms speak? IMHO, if some1 has a q, y not let em ask w/out saying WTF? I've come to the point where I tend to skip over sms-style posts and if the word 'u' is used I will completely ignore the entry. The IT world is so full of acronyms, abbreviations and made up technical terms that ...

Use "\x37"

you can use any of the conversion functions that have an rtype attribute and choose the rounding method of nearest in order to do that for you.

Me too, but the new logo is cool

...I did the preprocessing outside Datastage in UNIX and no luck... Does that mean that the extra spaces didn't get trimmed out in the preprocessing? If you add another output to a stage right before the DB2 write and output your FIELD3 value does it still have duplicate spaces? What stage and meth...

The SOUNDEX() function might catch some additional variants of this as well.

If you define a stage variable and then use that variable in only one derivation you will have a bit more overhead than by doing the computation directly in the derivation. If you use the stage variable result more than once (be it a derivation or a constraint or another stage variable) then is more...

You are doing 2 actions - the first is the FIELD() function and the next is the insert into the database. We need to eliminate one or the other. Have you done your FIELD() function into a string variable and then outputted that value to a PEEK stage or sequential file to confirm what the extracted s...

Ray,

could you help me with a DS problem? I have a program that will not compile. It has several stages and parameters and I also added comments. Why is this happening? Should I change my uvconfig file or reinstall the server?

Sounds like the to_number() is being called correctly. Can you add an output column to a peek stage that contains the string value that you are extracting to make sure that it is actually getting "700.123" in the string. Also, could you manually insert a row using your favorite tool with to_number('...

I guess that keeps the {initial} migration costs down So all you need to do is go into the Designer for each job, drop Teradata stages onto the canvas and move the link over from the original Oracle stages. Fill in a couple of parameters and Bob's your uncle. Why hire specialists for that, just get ...

What mask did you use in the to_number function and what is the SQL datatype in the database?

Craig - I guess I really can't count. Silly me.

Naren6876 - Please ignore my earlier post and follow Master Craig's suggestion.

Business rules are usually written in natural English language while transform logic is written in a programming language.

Going from one of these to the other can only be done by a human.

Such a migration project will, of necessity, involve a lot of thought about reorganizing the tables in order to take advantage of differences in architecture. Since those changes will also affect the ETL layer the real answer is that a migration from Oracle to Teradata will never be a simple one; an...