One Star

[resolved] why is tDenormalize not actually denormalizing?

I made a job in 3.0 that works fine (3rd and 4th pics). When I mimic'ed that job set up in 2.4.1 (1st and 2nd pics), the tDenormalize did not behave as expected.
in 3.0.0, this was the output of tDenormalize (which is what I want it to look like)
ID_BB_COMPANY|LONG_COMP_NAME|COUNTRY_ISO|SHORT_NAME|SECURITY_TYP|MARKET_SECTOR_DES|QUOTE_TYP|DAY_CNT|PAR_AMT|MTG_FIRST_PAY_DT|CPN|MTG_ORIG_AMT|ISSUE_DT|ISSUE_PX|MATURITY|CRNCY|EXCH_CODE|CPN_FREQ|MTG_COLLAT_TYP|CPN_TYP|MTG_FACTOR_DT|DAYS_ACC|DELIVERY_TYP|FIRST_SETTLE_DT|144A_FLAG|IS_ACCRED_INV|CALLABLE|CONVERTIBLE|FLOATER|MTG_IS_PAID_OFF|OID_BOND|PRVT_PLACE|IS_REG_S|LEAD_MGR|MARKET_SECTOR|MTG_AMORT_TYP|MTG_ARM_SUBTYP|MTG_CMO_CLASS|MTG_CMO_GROUP|MTG_CMO_SERIES|MTG_COLLAT_DT|MTG_COLLAT_SEASONING|MTG_COMPLIANCE_CODE|MTG_CUR_PAY_RT|MTG_DEAL_TYP|MTG_EST_ACC_RT|MTG_FACTOR_NUM_DT|MTG_FACTOR_SET_DT|MTG_FFIEC_TEST|MTG_GEN_TICKER|MTG_GEO|MTG_IS_MEGA|MTG_LOOKBACK|MTG_NOTL_PRINC_FLAG|MTG_ORIG_SERV_LINE1|MTG_ORIG_WAC|MTG_ORIG_WAL|MTG_ORIG_WAM|MTG_PAY_CAP|MTG_PAY_DELAY|MTG_PER_RT_CAP|MTG_POOL_FACTOR|MTG_POOL_NUMBER|MTG_POOL_TYP|MTG_PREPAY_TYP|MTG_RT_CHG_FREQ|MTG_SERV|MTG_SMMEA_STAT|MTG_STATED_DT|MTG_TRANCHE_TYP|MTG_TYP|MTG_WAM_NXT_RST|NXT_CALL_DT|NXT_CALL_PX|NXT_CPN_DT|NXT_PUT_DT|NXT_PUT_PX|MTG_FLT_NXT_RST|NXT_SINK_AMT|PREV_CPN_DT|ID_BB_UNIQUE|SEC_DATE_2A_7|SECURITY_DES|SECURITY_TYP2|SETTLE_DT|STATE_CODE|TICKER|RESET_IDX|TRADE_STATUS|MTG_CALL_PCT|MTG_CRED_PROV|MTG_PREV_CPN|CUR_CPN|MIN_PIECE|MTG_IS_AGENCY_BACKED|ISSUER|NAME|ISSUER_BULK|CNTRY_OF_DOMICILE|CNTRY_OF_INCORPORATION|ID_BB_PARENT_CO|MULTI_CPN_SCHEDULE|MULTI_CPN_SCHEDULE_TYP|REDEMP_CRNCY|CALL_SCHEDULE|PUT_SCHEDULE|SINK_SCHEDULE|COLLAT_ARM_INDEX_1|COLLAT_ARM_INDEX_2|COLLAT_ARM_INDEX_3|COLLAT_ARM_INDEX_ALL|ID_CUSIP|ID_CUSIP_8_CHR|ID_ISIN|ID_CUSIP_REAL|ID_SEDOL1|ID_VALOREN|RTG_FITCH|FITCH_EFF_DT|RTG_FITCH_LONG|RTG_FITCH_LONG_RATING_DT|RTG_FITCH_NO_WATCH|RTG_FITCH_OUTLOOK|RTG_FITCH_OUTLOOK_DT|RTG_FITCH_SHRT|RTG_FITCH_SHRT_RATING_DT|RTG_MOODY|MOODY_EFF_DT|RTG_MOODY_LONG|RTG_MDY_LONG_RATING_DT|RTG_MOODY_NO_WATCH|RTG_MOODY_SHRT|RTG_MDY_SHRT_RATING_DT|RTG_MOODY_WATCH|RTG_MOODY_WATCH_DT|RTG_SP|SP_EFF_DT|RTG_SP_LONG|RTG_SP_LONG_RATING_DT|RTG_SP_NO_WATCH|RTG_SP_SHRT|RTG_SP_SHRT_RATING_DT|INDUSTRY_GROUP|INDUSTRY_SECTOR|INDUSTRY_SUBGROUP_NUM|MTG_SPREAD_TO_TSY_MID|LAST_UPDATE_DT|PX_ASK|PX_BID|PX_LAST|PX_MID|QUOTE_ASK|QUOTE_BID|QUOTE_MID|AMT_OUTSTANDING|CNVX_MID|COLLAT_ARM_PERCENT_ALL|COLLAT_ARM_PERIODIC_CAP_1|COLLAT_ARM_PERIODIC_CAP_2|COLLAT_ARM_PERIODIC_CAP_3|COLLAT_ARM_PERIODIC_CAP_ALL|COLLAT_ARM_PERCENT_1|COLLAT_ARM_PERCENT_2|COLLAT_ARM_PERCENT_3|COLLAT_ARM_WA_CAP_1|COLLAT_ARM_WA_CAP_2|COLLAT_ARM_WA_CAP_3|COLLAT_ARM_WA_CAP_ALL|COLLAT_ARM_WA_FLOOR_1|COLLAT_ARM_WA_FLOOR_2|COLLAT_ARM_WA_FLOOR_3|COLLAT_ARM_WA_FREQ_1|COLLAT_ARM_WA_FREQ_2|COLLAT_ARM_WA_FREQ_3|COLLAT_ARM_WA_FREQ_ALL|COLLAT_ARM_WA_GROSS_MARGIN_1|COLLAT_ARM_WA_GROSS_MARGIN_2|COLLAT_ARM_WA_GROSS_MARGIN_3|COLLAT_ARM_WA_GROSS_MARGIN_ALL|COLLAT_ARM_WA_NET_MARGIN_ALL|COLLAT_ARM_WA_RESET_DATE_1|COLLAT_ARM_WA_RESET_DATE_2|COLLAT_ARM_WA_RESET_DATE_3|COLLAT_ARM_WA_RESET_DATE_ALL|COLLAT_ARM_WAC_1|COLLAT_ARM_WAC_2|COLLAT_ARM_WAC_3|COLLAT_ARM_WAC_ALL|COLLAT_ARM_WA_FLOOR_ALL|COLLAT_ARM_WA_NET_MARGIN_1|COLLAT_ARM_WA_NET_MARGIN_3|DAYS_TO_MTY_TDY|DUR_ADJ_MID|DUR_MID|INT_ACC|MOST_RECENT_REPORTED_FACTOR|MTG_ACC_RT|MTG_ACC_RT_START_DT|MTG_AMORT_WAM|MTG_AMT_OUT_FACE|MTG_BALLOON_WAM|MTG_CARD_MPR|MTG_CREDIT_SCORE_WAVG|MTG_EFF_CNVX_MID|MTG_EFF_DUR_MID|MTG_EXS_SPREAD|MTG_FACTOR|MTG_FACT_SET_DT_STRT_NEXT_ACC_DT|MTG_FACTOR_INT_PAY|MTG_FACTOR_PAY_DT|MTG_GEN_CPR_12M|MTG_GEN_CPR_1M|MTG_GEN_CPR_3M|MTG_GEN_CPR_6M|MTG_HIST_CHARGE_OFF_1MO|MTG_INT_DEFERRED|MTG_INT_DIST|MTG_INT_SHORTFALL|MTG_LOAN_AGE|MTG_LOAN_MRGN|MTG_LOAN_SIZE_WAVG|MTG_LOCK_WAM|MTG_ORIG_LFLOOR_AVG|MTG_PL_CPR_12M|MTG_PL_CPR_1M|MTG_PL_CPR_3M|MTG_PL_CPR_6M|MTG_PORT_YLD|MTG_PREPAY_SPEED|MTG_PX_SPD|MTG_QRT_AOLS_MAX|MTG_QRT_ASOF_DT|MTG_QRT_AOLS_MED|MTG_QRT_LTV_MED|MTG_QRT_SCORE_MAX|MTG_QRT_SCORE_MED|MTG_STATED_NUM_DT|MTG_STATED_WALA|MTG_STATED_WARM|MTG_WAC_CALC|MTG_WAC_WAVG|MTG_WACPN|MTG_WAL|MTG_WALA_CALC|MTG_WAM|MTG_WAM_WAVG|MTG_WAOCS|MTG_WHLN_LTV|MTG_WHLN_NUMBER_LOAN|MTG_WHLN_WALA|MTY_YEARS|OAS_SPREAD_ASK|OAS_SPREAD_BID|OAS_SPREAD_MID|YLD_CUR_ASK|YLD_CUR_BID|YLD_CUR_MID|YLD_VAL_32ND_MID|YLD_YTC_MID|YLD_YTM_MID|YLD_YTP_MID|FLT_SPREAD|MTG_LIFE_CAP|MTG_LIFE_FLOOR|REFIX_FREQ|MTG_HIST_CPN|MTG_FLT_LAST_RST|BASIC_SPREAD|REFERENCE_INDEX|FLT_MAX_CPN|FLT_MIN_CPN|YLD_CNV_BID|YLD_CNV_ASK|YLD_CNV_MID|CUM_LOSS_PCT|CURR_CREDIT_SUPPORT|CURR_CUM_LOSS_AMT|MTG_2_4_FAMILY_CURR|MTG_AMORT_TYPE_LEVEL_FRM_CURR|MTG_BAL|MTG_CONDOMINIUM_CURR|MTG_CUR_PRINC_PAY|MTG_CUR_PAY_DT|MTG_DELQ_90PLUS_CUR|MTG_FACTOR_PRINC_PAY|MTG_NORTHERN_CA_CURR|MTG_PREV_BAL|MTG_PRINC_LOSSES|MTG_PUD_CURR|MTG_QRT_AGE_25|MTG_QRT_AGE_75|MTG_QRT_AGE_MAX|MTG_QRT_AGE_MED|MTG_QRT_AGE_MIN|MTG_QRT_AOLS_25|MTG_QRT_AOLS_75|MTG_QRT_AOLS_MIN|MTG_QRT_CPN_25|MTG_QRT_CPN_75|MTG_QRT_CPN_MAX|MTG_QRT_CPN_MED|MTG_QRT_CPN_MIN|MTG_QRT_LTV_25|MTG_QRT_LTV_75|MTG_QRT_LTV_MAX|MTG_QRT_LTV_MIN|MTG_QRT_MTY_25|MTG_QRT_MTY_75|MTG_QRT_MTY_MAX|MTG_QRT_MTY_MED|MTG_QRT_MTY_MIN|MTG_QRT_SCORE_25|MTG_QRT_SCORE_75|MTG_QRT_SCORE_MIN|MTG_QRT_TERM_25|MTG_QRT_TERM_75|MTG_QRT_TERM_MAX|MTG_QRT_TERM_MED|MTG_QRT_TERM_MIN|MTG_SINGLE_FAMILY_CURR|MTG_SOUTHERN_CA_CURR|MTG_WHLN_WALTV|ORIG_CREDIT_SUPPORT|MTG_WHLN_GEO1|MTG_WHLN_GEO2|MTG_WHLN_GEO3|MTG_WHLN_GEO4|MTG_PRINC_DIST|MTG_CURR_LOAN_SIZE_WAVG|MTG_DEAL_CUR_COLLAT_AMT|RTG_FITCH_WATCH|RTG_FITCH_WATCH_DT|RTG_SP_WATCH|RTG_SP_WATCH_DT|MTG_FIRST_RESET_CAP_UP|MTG_WA_ORIG_LOAN_SIZE|ARM_WA_MONTHS_TO_INIT_RST|COLLAT_ARM_LOAN_TYP_1|MTG_AMORT_TYPE_ARM_CURR

but in 2.4.1, this was the output of tDenormalize
OID_BOND
MTG_POOL_TYP
MTG_CRED_PROV
MTG_FACTOR_DT
DAY_CNT
MTG_STATED_WARM
MTG_FACTOR_PAY_DT
MTG_QRT_CPN_MAX
MTG_BAL
ID_BB_UNIQUE
SEC_DATE_2A_7
MTG_QRT_SCORE_25
MTG_AMORT_TYPE_LEVEL_FRM_CURR
MTG_WHLN_NUMBER_LOAN
MTG_ORIG_LFLOOR_AVG
COLLAT_ARM_WA_CAP_ALL
MTG_EFF_CNVX_MID
MTG_AMT_OUT_FACE
RTG_MOODY_WATCH_DT
MTG_QRT_LTV_MED
MTG_QRT_AOLS_MIN
LAST_UPDATE_DT
MTG_QRT_AGE_75
CRNCY
MTG_PRINC_DIST
ID_CUSIP
COLLAT_ARM_WA_FREQ_ALL
MTG_QRT_ASOF_DT
MTG_LOAN_AGE
QUOTE_TYP
MTG_CUR_PAY_RT
MTG_TRANCHE_TYP
MTG_QRT_TERM_MAX
RTG_FITCH_NO_WATCH
RESET_IDX
MTG_WHLN_WALA
MTG_EST_ACC_RT
OAS_SPREAD_MID
MTG_GEN_TICKER
RTG_FITCH
RTG_MOODY_NO_WATCH
MTG_QRT_AOLS_25
INDUSTRY_GROUP
NXT_CALL_DT
MTG_LIFE_FLOOR
NXT_SINK_AMT
RTG_SP
IS_ACCRED_INV
PUT_SCHEDULE
RTG_FITCH_SHRT_RATING_DT
MTG_RT_CHG_FREQ
PX_MID
MTG_QRT_AGE_MAX
FLT_SPREAD
YLD_CNV_ASK
INDUSTRY_SUBGROUP_NUM
MTG_QRT_MTY_MED
MTG_GEO
NXT_PUT_PX
CPN_TYP
COLLAT_ARM_LOAN_TYP_1
MTG_QRT_MTY_25
RTG_SP_SHRT
LEAD_MGR
PAR_AMT
MTG_QRT_CPN_25
MTG_SINGLE_FAMILY_CURR
QUOTE_MID
MTG_LIFE_CAP
YLD_YTP_MID
MTG_PX_SPD
MTG_INT_DEFERRED
COLLAT_ARM_PERCENT_1
COLLAT_ARM_PERCENT_2
MATURITY
MTG_CMO_SERIES
COLLAT_ARM_PERCENT_3
RTG_FITCH_LONG_RATING_DT
RTG_SP_NO_WATCH
MTG_WAC_CALC
MTY_YEARS
MTG_CMO_CLASS
NXT_CPN_DT
COLLAT_ARM_WA_NET_MARGIN_3
RTG_SP_WATCH_DT
MTG_FACTOR_SET_DT
COLLAT_ARM_WA_NET_MARGIN_1
MTG_IS_AGENCY_BACKED
RTG_MOODY_SHRT
MTG_IS_PAID_OFF
ISSUER_BULK
MTG_QRT_AOLS_MED
MIN_PIECE
MTG_SERV
MTG_HIST_CPN
YLD_VAL_32ND_MID
MTG_FACTOR_INT_PAY
MTG_CURR_LOAN_SIZE_WAVG
MTG_QRT_TERM_75
COLLAT_ARM_WA_FREQ_2
COLLAT_ARM_WA_FREQ_1
ARM_WA_MONTHS_TO_INIT_RST
MTG_QRT_CPN_MED
ID_ISIN
COLLAT_ARM_WA_FREQ_3
MTG_QRT_AOLS_75
MTG_QRT_SCORE_MED
RTG_SP_LONG
MTG_AMORT_TYP
PX_BID
MTG_WAC_WAVG
IS_REG_S
MTG_LOAN_MRGN
MTG_PL_CPR_1M
MTG_QRT_LTV_MAX
COLLAT_ARM_WA_FLOOR_ALL
SECURITY_TYP2
MTG_COLLAT_SEASONING
MTG_POOL_NUMBER
SECURITY_TYP
OAS_SPREAD_BID
MTG_CUR_PAY_DT
COLLAT_ARM_WA_RESET_DATE_1
MTG_ORIG_SERV_LINE1
COLLAT_ARM_WA_RESET_DATE_2
MOST_RECENT_REPORTED_FACTOR
COLLAT_ARM_WA_RESET_DATE_3
MTG_QRT_LTV_75
RTG_FITCH_SHRT
MTG_FIRST_PAY_DT
MTG_TYP
LONG_COMP_NAME
MTG_QRT_CPN_75
MTG_2_4_FAMILY_CURR
SHORT_NAME
MTG_QRT_MTY_MIN
MTG_PREV_BAL
PREV_CPN_DT
EXCH_CODE
SETTLE_DT
NXT_CALL_PX
MTG_EXS_SPREAD
MTG_NOTL_PRINC_FLAG
MTG_WAM_WAVG
MTG_LOCK_WAM
MTG_STATED_DT
MTG_LOOKBACK
MTG_QRT_SCORE_MAX
COUNTRY_ISO
MTG_WHLN_GEO2
MTG_WHLN_GEO3
MTG_QRT_AOLS_MAX
MTG_WHLN_GEO1
REFIX_FREQ
RTG_FITCH_OUTLOOK_DT
MTG_WHLN_WALTV
MTG_DELQ_90PLUS_CUR
COLLAT_ARM_WA_GROSS_MARGIN_1
ID_CUSIP_REAL
QUOTE_ASK
COLLAT_ARM_WA_GROSS_MARGIN_3
MTG_SOUTHERN_CA_CURR
COLLAT_ARM_WA_GROSS_MARGIN_2
COLLAT_ARM_INDEX_ALL
MTG_WAL
YLD_CUR_MID
ID_VALOREN
MTG_QRT_AGE_25
MTG_WAM_NXT_RST
MTG_ORIG_AMT
MTG_WAM
NXT_PUT_DT
MULTI_CPN_SCHEDULE_TYP
COLLAT_ARM_WA_GROSS_MARGIN_ALL
BASIC_SPREAD
MTG_LOAN_SIZE_WAVG
MTG_WHLN_GEO4
SINK_SCHEDULE
MTG_FACTOR
RTG_MOODY_WATCH
RTG_SP_SHRT_RATING_DT
CNVX_MID
RTG_FITCH_OUTLOOK
MTG_PAY_CAP
ISSUE_DT
COLLAT_ARM_WAC_1
MTG_QRT_TERM_MIN
MTG_CARD_MPR
COLLAT_ARM_WAC_2
COLLAT_ARM_WAC_3
AMT_OUTSTANDING
RTG_MOODY
REFERENCE_INDEX
MTG_ACC_RT
COLLAT_ARM_INDEX_2
MTG_AMORT_TYPE_ARM_CURR
COLLAT_ARM_INDEX_3
YLD_CUR_BID
MTG_EFF_DUR_MID
COLLAT_ARM_INDEX_1
MTG_QRT_MTY_75
MTG_PL_CPR_6M
MTG_GEN_CPR_6M
MTG_DEAL_CUR_COLLAT_AMT
COLLAT_ARM_PERIODIC_CAP_ALL
NAME
REDEMP_CRNCY
MTG_INT_SHORTFALL
MTG_PER_RT_CAP
CALL_SCHEDULE
MTG_QRT_CPN_MIN
MTG_PREPAY_SPEED
MARKET_SECTOR
YLD_YTC_MID
MTG_QRT_TERM_25
MTG_FACT_SET_DT_STRT_NEXT_ACC_DT
RTG_FITCH_LONG
MTG_QRT_SCORE_MIN
CUR_CPN
144A_FLAG
TRADE_STATUS
MTG_WALA_CALC
YLD_YTM_MID
PX_LAST
MTG_STATED_WALA
MTG_ACC_RT_START_DT
MTG_FFIEC_TEST
MTG_GEN_CPR_3M
SP_EFF_DT
COLLAT_ARM_WA_CAP_1
MTG_QRT_SCORE_75
COLLAT_ARM_WA_CAP_2
RTG_FITCH_WATCH
RTG_SP_LONG_RATING_DT
COLLAT_ARM_WA_NET_MARGIN_ALL
CURR_CREDIT_SUPPORT
MTG_FACTOR_NUM_DT
COLLAT_ARM_WA_CAP_3
FITCH_EFF_DT
COLLAT_ARM_WA_FLOOR_3
COLLAT_ARM_WA_FLOOR_2
TICKER
COLLAT_ARM_WA_FLOOR_1
ID_BB_COMPANY
MTG_QRT_LTV_25
MTG_ORIG_WAC
DAYS_ACC
MULTI_CPN_SCHEDULE
MTG_INT_DIST
ISSUER
OAS_SPREAD_ASK
PRVT_PLACE
CUM_LOSS_PCT
MTG_ORIG_WAL
CALLABLE
MTG_ORIG_WAM
MTG_NORTHERN_CA_CURR
MTG_WHLN_LTV
MTG_GEN_CPR_12M
MTG_HIST_CHARGE_OFF_1MO
CNTRY_OF_INCORPORATION
YLD_CNV_MID
DUR_MID
MTG_QRT_AGE_MIN
CNTRY_OF_DOMICILE
PX_ASK
MTG_BALLOON_WAM
FIRST_SETTLE_DT
MTG_PL_CPR_3M
RTG_MDY_LONG_RATING_DT
MTG_PL_CPR_12M
MTG_CMO_GROUP
RTG_MDY_SHRT_RATING_DT
COLLAT_ARM_WA_RESET_DATE_ALL
MTG_PUD_CURR
RTG_SP_WATCH
MTG_QRT_TERM_MED
MTG_GEN_CPR_1M
MTG_PREV_CPN
FLT_MAX_CPN
ID_SEDOL1
MTG_CONDOMINIUM_CURR
DELIVERY_TYP
RTG_FITCH_WATCH_DT
SECURITY_DES
COLLAT_ARM_PERIODIC_CAP_2
COLLAT_ARM_PERIODIC_CAP_3
MTG_DEAL_TYP
COLLAT_ARM_PERIODIC_CAP_1
MTG_QRT_LTV_MIN
CONVERTIBLE
MTG_COMPLIANCE_CODE
MTG_COLLAT_TYP
INDUSTRY_SECTOR
COLLAT_ARM_PERCENT_ALL
MTG_CALL_PCT
QUOTE_BID
YLD_CUR_ASK
MTG_IS_MEGA
MOODY_EFF_DT
ID_CUSIP_8_CHR
RTG_MOODY_LONG
MTG_WAOCS
YLD_CNV_BID
FLOATER
ID_BB_PARENT_CO
MTG_CUR_PRINC_PAY
COLLAT_ARM_WAC_ALL
MTG_CREDIT_SCORE_WAVG
ISSUE_PX
MTG_STATED_NUM_DT
CPN
INT_ACC
MTG_ARM_SUBTYP
DAYS_TO_MTY_TDY
MTG_PORT_YLD
MTG_PAY_DELAY
CPN_FREQ
MTG_SMMEA_STAT
MTG_WACPN
MTG_COLLAT_DT
DUR_ADJ_MID
MTG_PREPAY_TYP
ORIG_CREDIT_SUPPORT
MTG_FIRST_RESET_CAP_UP
MTG_FLT_LAST_RST
MTG_WA_ORIG_LOAN_SIZE
MTG_QRT_AGE_MED
CURR_CUM_LOSS_AMT
MTG_AMORT_WAM
MTG_POOL_FACTOR
MARKET_SECTOR_DES
STATE_CODE
MTG_QRT_MTY_MAX
MTG_SPREAD_TO_TSY_MID
MTG_PRINC_LOSSES
MTG_FACTOR_PRINC_PAY
FLT_MIN_CPN
MTG_FLT_NXT_RST
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] why is tDenormalize not actually denormalizing?

Hi Jessica,
I'll try to guess. I actual use 2.4.x
Do you have only one column (named line) in your flow?
If so 2.4.x is working right because in the column list the "group by clause" is defined. If you only have one column, do not enter any value in this option box.
In 3.0.0 the box is named "To denormalize" so I would say there is a semantic change in the dialog. In 3.0.0 you have to define what to denormalize (in this case the rest is the group by clause).
Bye
Volker
2 REPLIES
One Star

Re: [resolved] why is tDenormalize not actually denormalizing?

Hi Jessica,
I'll try to guess. I actual use 2.4.x
Do you have only one column (named line) in your flow?
If so 2.4.x is working right because in the column list the "group by clause" is defined. If you only have one column, do not enter any value in this option box.
In 3.0.0 the box is named "To denormalize" so I would say there is a semantic change in the dialog. In 3.0.0 you have to define what to denormalize (in this case the rest is the group by clause).
Bye
Volker
One Star

Re: [resolved] why is tDenormalize not actually denormalizing?

ohok, that makes sense
thanks!