Hello all,
I have one column in source with length 30 character. I am loading 30 columns in target oracle table, each column in target table have length char(1). My job is like this
Seq. file -->Column Import-->Transformer-->Oracle Table
Also I am getting HEX ('00') value in my source. To avoid this I am using below environment variable APT_STRING_PADCHAR = one space (' ')
The function I am using here is for derivation in transformer stage
TrimLeadingTrailing(Trim(FF_cal_cd,char(0),"B"))
The above function work fine for 29 columns out of 30 columns.
Only one column have issue and loading HEX value ('00'). I have the issue in FF_hot_bill_cd column. I am not able to apply below logic for FF_hot_bill_cd column.
TrimLeadingTrailing(Trim(FF_hot_bill_cd,char(0),"B"))
When I am doing TrimLeadingTrailing() function or Trim() I am not able to compile the job and get the message for the above derivation. If I put FF_hot_bill_cd column without derivation, I am able to compile the job but loading HEX '00' value
Error message while compiling the job:-
##W TFCP 000025 04:23:23(101) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 04:23:23(102) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "String".
##W TBLD 000000 04:23:23(103) <main_program> Error when checking composite operator: Output from subprocess: compiler(iropt) error: out of memory
Why I am getting this issue "out of memory". What I need to do here? Can I set any environment variable to increase memory?
Any help would be highly appreciated.
Not able to compile job error in transformer stage
-
- Participant
- Posts: 68
- Joined: Wed Jan 10, 2007 11:24 pm
Not able to compile job error in transformer stage
ETL DEVELOPER
Watch The Time Cycle, You Will Have All Answers.
Watch The Time Cycle, You Will Have All Answers.
-
- Participant
- Posts: 56
- Joined: Fri Sep 21, 2007 9:10 am
- Location: Bangalore
I vaguely recall having seen this before as well, and it was a compiler-related issue. I think I changed the compiler optimization switches around to get rid of the error. If you google your platform, compiler and the error message you might be able to get more information.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 68
- Joined: Wed Jan 10, 2007 11:24 pm
Thank you for reply. But I am taking source column ff_hot_bill_cd as char(1) and applying logic on it.
TrimLeadingTrailing(Trim(FF_hot_bill_cd,char(0),"B"))
Target column also same with datatype char(1).
I was also thinking why this error message coming to my way. all the other 29 columns also char(1) in source as well as target.
TrimLeadingTrailing(Trim(FF_hot_bill_cd,char(0),"B"))
Target column also same with datatype char(1).
I was also thinking why this error message coming to my way. all the other 29 columns also char(1) in source as well as target.
ETL DEVELOPER
Watch The Time Cycle, You Will Have All Answers.
Watch The Time Cycle, You Will Have All Answers.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 68
- Joined: Wed Jan 10, 2007 11:24 pm