- Posts: 371
- Thank you received: 3
Email to Support regarding transformation vs package results
9 years 10 months ago #8549
by ckelsoe
Hi,
This is the same as the last issue I emailed you, however, I cannot find any offending queries or design issues that is causing the problem.
Basically I have some fields added together using the Add transformation. I then am adding the results of several Add transformations. Running the transformation with the records filtered works great. Run the same transformation on all source records gets bad results on two of the add transformations.
I have tore apart every query and dug into the transformation for the past 8+ hours and am not getting anywhere.
Help!!
And Thank You!
This is the same as the last issue I emailed you, however, I cannot find any offending queries or design issues that is causing the problem.

Basically I have some fields added together using the Add transformation. I then am adding the results of several Add transformations. Running the transformation with the records filtered works great. Run the same transformation on all source records gets bad results on two of the add transformations.
I have tore apart every query and dug into the transformation for the past 8+ hours and am not getting anywhere.
Help!!
And Thank You!
Please Log in or Create an account to join the conversation.
9 years 10 months ago #8552
by admin
Mike
ETL Architect
Replied by admin on topic Email to Support regarding transformation vs package results
We will have a look at it later today.
We had servel customers with simular issues and it was because
Thery run the package but the did not save the transformation first.
So they we running old transformation
Peter
We had servel customers with simular issues and it was because
Thery run the package but the did not save the transformation first.
So they we running old transformation
Peter
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
9 years 10 months ago #8556
by ckelsoe
Replied by ckelsoe on topic Email to Support regarding transformation vs package results
I have noticed that issue also. I do no think that is the case as I have been saving each transformation often as I have been bit by work not getting saved. I close all transformations before running the package.
Please Log in or Create an account to join the conversation.
9 years 10 months ago #8557
by admin
Mike
ETL Architect
Replied by admin on topic Email to Support regarding transformation vs package results
I am really struggling to understand which package and transformation shall I run to reproduce the problem
Perhaps you can email us another repository backup saying run this and that
Mike
Perhaps you can email us another repository backup saying run this and that
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
9 years 10 months ago #8571
by admin
Mike
ETL Architect
Replied by admin on topic Email to Support regarding transformation vs package results
We have reproduced the problem
Mike
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
9 years 10 months ago #8573
by ckelsoe
Replied by ckelsoe on topic Email to Support regarding transformation vs package results
You mean I have not totally lost my mind?? :woohoo:
Please Log in or Create an account to join the conversation.