Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rounding Data in FDM from SQL Table

2810743Mar 4 2014 — edited Mar 5 2014

I am trying to round data in FDM Action > Export script as the data is coming from SQL Table without rounding.

I have update the Export script with below but it does not make any changes to the Dat file.

Has anyone used this in the Adaptor Export script?

'Amount

    strLine = strLine & Round(rsExport.Fields("Amount").Value)& strDelim

Thanks

Comments

J.A.

Hi

Truncate is a DDL operation, do you have DDL replication enable ? in your OGG environment

Maybe you need a historical table on your target DB, so maybe you can create a Job to copy the Data from the target table to the historical table.

Regards

Frak!!!

you need to check if you have enable a DDL replication at the source database? if the DDL installed and enabled, you can control which DDL to capture from the extract and replicat by using DDL Include and DDL exclude parameters.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 2 2014
Added on Mar 4 2014
4 comments
149 views