Forum Discussion

RR_OneS_QPO's avatar
RR_OneS_QPO
New Contributor II
2 years ago
Solved

Pointing to a Functional Currency Field from USD Amount Field in Direct Connection

What is the best approach to point to a different field in a Direct Connection Data Source.  I am familiar with importing both local and USD currency (not using translation) by selecting the appropr...
Data Integration
  • RR_OneS_QPO's avatar
    RR_OneS_QPO
    2 years ago

    After a deeper review, I found that the process I followed to get the right value in the amount column using the Global Variables in the connector was actually adequate. The issue turned out to be: The sql view provided by the client was actually returning a transactional currency value in the USD field.

    Thank you for your response.

JackLacava's avatar
JackLacava
Community Manager
2 years ago

I think we need a bit more clarity here. Correct me if I'm wrong:

  • You have a Connector you wrote to pull data from some arbitrary source
  • you're running some Transformation rule on it, to manipulate values (?) and that's what is failing
  • I'm not sure what you mean by Direct - Direct Load is a Workflow mode, are you using that to run your Connector?

Generally speaking, if you're in control of Connector code, it might be easier to do any "dirty work" there, presenting a clean and simple table to transformation rules. Grab the source data, then modify the DataTable or create a new one that contains "clean" records. 

There isn't (or rather shouldn't) be any meaningful difference between Connectors or Fixed/Delimited Files, in terms of how Transformation Rules run and reference source data; I believe there might be some differences in how those rules run if you're using Direct Load, but again, if you're using Direct Load you're doing it for speed, so you'd want to keep your transformations simple and fast and do the heavy lifting inside the Connector.

  • RR_OneS_QPO's avatar
    RR_OneS_QPO
    New Contributor II
    2 years ago

    After a deeper review, I found that the process I followed to get the right value in the amount column using the Global Variables in the connector was actually adequate. The issue turned out to be: The sql view provided by the client was actually returning a transactional currency value in the USD field.

    Thank you for your response.