HomeForum
Welcome, Guest

Tranforming Oracle Data
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Tranforming Oracle Data

Tranforming Oracle Data 11 months, 3 weeks ago #2806

  • SteveK
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Karma: 0
Hello,

We are currently in the process of reviewing ETL applications. We recently spent some time reviewing your Advanced ETL Processor tool. We were excited about its functionality and found it to be very user friendly. Our trial period has expired so we decided to download and look into your Advanced ETL Processor Professional tool. Our Operating System is Microsoft Windows XP Professional, version 5.1. and our database is Oracle 9i.

We are encountering a problem and would appreciate your help. I have set up a simple transformation where I am utilizing the “In List” and “Is Equal To” validations. I receive the following error when clicking on the “In List” validator to define the “In List Properties”. After clicking on OK, I can proceed to define the properties. However, the validation result of the “In List” validator is not correct. The Source Data for the “In list” is “Entered by User” and the Value List is abc. See screen shots below. I have also attached word document containing screen shots of the validation editor showing the fields with the validators as well as the incorrect results of the validation.

Thanks in advance for your assistance.
Steve
Attachments:

Re: Tranforming Oracle Data 11 months, 3 weeks ago #2807

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Steve

I believe the problem you reported was already fixed in latest version

I also recommend you to install following data access components as well

FoxPro ODBC driver

msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx



Office 2007 Data Access Components

www.microsoft.com/downloads/details.aspx...1&displaylang=en

Mike
  • Page:
  • 1
Time to create page: 0.16 seconds

Testimonials

Within an hour we were able  to populate fact and dimension tables in our datawarehouse using Advanced ETL Processor

P. Jonson

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top