Table comparison not detecting tab as change

dataservices job design
1

Hello BODS Gurus,

I will give you a brief description of the problem. Please let me know if the details are not good enough or need more details!

Source table Emp_source_feed

Empid EmpName
1 ABC
2 EFG

Target Table Emp_Target

Empid Empname
1 ABC
2 EFG (tab at the end)

My data flow:

Source table–> Query transform --> TC–> Target

Problem:

TC is not detecting a change on empname column(tab is the difference). So my target is not getting updated. Do any one know why? Is tab not considered as change there? Is there a workaround? Please let me know if i am missing something here. I have also tried space at the end of the above column value and its not detecting either.

Appreciate your time and help on this.

Thanks

kkr (BOB member since 2011-06-29)

2

I forgot to mention.
Target DB is Oracle.

kkr (BOB member since 2011-06-29)

3

I am not very sure but I would check if this has something to do with DS_CONFIG.txt. If there is any parameter set to truncate the TAB.

Hint - ANSI_Varchar_Behavior does delete the spaces if it is set to True.

BODSDW (BOB member since 2011-01-19)

4

Thanks for your reply. I will look into it as well.

kkr (BOB member since 2011-06-29)