Hi,
I am getting type conversion warning when transforming data from table to table. I have used SCD stage and the data type are varchars only.
I am getting a warning like this. Can anyone please tell me what would be the problem.
Thanks in advance.
##I IIS-DSEE-TFCN-00001 12:50:41(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 12:50:41(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:50:41(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:50:41(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:50:41(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 12:50:44(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 24,576.
##E IIS-DSEE-TFSR-00019 12:50:44(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 12:50:44(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##I IIS-DSEE-TBLD-00000 12:50:44(003) <main_program> Error when checking composite operator: Output from subprocess: C:\IBM\InformationServer\Server\PXEngine\include\apt_util\keylookup.h(1148) : warning C4251: 'APT_KeyLookupRange::rangeOptions_' : class 'std::vector<_Ty>' needs to have dll-interface to be used by clients of class 'APT_KeyLookupRange'
with
[
_Ty=APT_KeyLookupRange::rangeOption
]
C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(330) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\InformationServer\S
##I IIS-DSEE-TBLD-00000 12:50:44(004) <main_program> Error when checking composite operator: Output from subprocess: erver\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(338) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(377) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(697) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\Info
##I IIS-DSEE-TBLD-00000 12:50:44(005) <main_program> Error when checking composite operator: Output from subprocess: rmationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(715) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(862) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.C(914) : warning C4018: '<' : signed/unsigned mismatch
C:\IBM\InformationServer\Server\Projects\CPM_UAT\RT_BP132.O\V0S60_BI_AUM_AUA_TYPE_Slowly_Changing_Dimension.dll : fatal error LNK1120: 16 unresolved externals
Regards
Rudresh
Getting type conversion warning when transforming data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Wed Aug 29, 2007 1:33 am
- Location: Bangalore
- Contact:
Getting type conversion warning when transforming data
Rudresh Eswarappa
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The number of reject datasets "0" is less than the number of input datasets "1".
Search DSXchange for this exact message. Or just the first five words of it.
Search DSXchange for this exact message. Or just the first five words of it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.