Best way to replace Functions in FM

[Nandini.t]

Hi All,

Iam working on Oracle to Teradata Migration project. Actually FM model and Reports are all built using oracle as database now we are migrating database to teradata. So few functions are differing from oracle to teradata so please guide me the easiest way to alter the functions in the FM where the data source will b changed to teradata.

Thanks in advance,

[blom0344]

Do you mean hardcoded SQL within SQL query subjects? Though very much unsupported , you might consider hacking a copy of the model.xml and see if that works for you. Again, unsupported and you did not read it here  ;) 

[Nandini.t]

Hi bloom,

Thanks fr viewing and replying too. :)

Actually we are just changing the FM's eralier oracle data source to terdata. Few functions like to_char,to_number, and date related function is not similar in teradata compared to oracle. So we have to just change the mismatch oracle functions to teradata supported.
1 way v have is by taking Xml and replacing but, we have to write case statements for taradata to achieve a single word function in oracle, where it will be difficult to just find and replace. So i seek help to guide if any better n quality way to do this.

[blom0344]

Best practice is to use Cognos functions that are translated to the RDBMS syntax. Perhaps that does not work for Teradata (no idea), but using native code is a pitfall when having to do conversions

[Nandini.t]

Hi All...

Any reviews on this?? :(

[blom0344]

There is no find and replace, you need to rework this. That is the case when you do not use the flexible solution of using Cognos syntax.