HomeForum
Welcome, Guest

Data Transformation Troubleshooting Tips
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Data Transformation Troubleshooting Tips

Data Transformation Troubleshooting Tips 1 year, 2 months ago #1886

  • john
  • OFFLINE
  • Junior Boarder
  • Posts: 23
  • Karma: -1
I am wondering what the rest of AETL users do to help troubleshoot a complex data transformation mapping.
What can I do when the output doesn't match what I think it should be?

I follow the logic from front to back again and again, but the results just don't match what I expect.

Could you please share any trouble shooting tips you might have?

John

Re: Data Transformation Troubleshooting Tips 1 year, 2 months ago #1887

  • Joseph
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Hi,

through extensive past experience, the best thing that you can do is to SIMPLIFY your mapping as much as possible to narrow down the problem areas

Joseph

Re: Data Transformation Troubleshooting Tips 1 year, 2 months ago #1888

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
Totally agree with Joseph.

Also

Start from the left and move to the right.
Spit complex transformations into several simple ones
Use data preview all the time
Enter and test your own data

Peter
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

Advanced ETL Processor's ability to validate and tranform data without actually loading it into the datawarehouse has saved us a lot of time. We were able to see how data will look like, once it is transformed and which records would fail during data validation.

Antony Clark,
RBS 

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