" /> Can I modify the view of ETL DB? - Genesys CTI User Forum

Author Topic: Can I modify the view of ETL DB?  (Read 918 times)

Offline cmpark

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
Can I modify the view of ETL DB?
« on: November 03, 2022, 06:21:38 AM »
Advertisement
[code]
CREATE view [dbo].[V_A_CALL_NO_AGG] AS SELECT TIME_KEY, OBJECT_ID ,N_TRAN,N_CONF,T_RING,N_IB_REP,N_CONST,T_HOLD_OB,N_CONST_T,N_CONST_R,N_IB,T_TRAN,T_IB_REP,T_RING_OB,N_ABN_30,T_CONF,N_OB_ST,T_INT,N_INT,T_ABN,N_HOLD_OB,N_RING_INT,N_ABN,N_RING_IB,T_DIAL_INT,N_DIAL,T_OB,N_ABN_20,T_RING_INT,N_OB,T_IB,T_TRAN_R,T_TRAN_T,N_TRAN_R,T_DIAL,N_DIAL_OB,T_HOLD_IB,N_DIAL_INT,N_CONF_T,N_TRAN_T,N_CONF_R,N_INT_T,N_INT_R,T_RING_IB,N_ABN_10,N_HOLD_IB,T_CONF_T,T_DIAL_OB,T_CONST,N_HOLD,T_INT_R,T_CONF_R,T_IB_GEN,T_INT_T,T_CONST_T,T_CONST_R,N_IB_ST,N_IB_GEN,N_RING_OB,T_HOLD,N_RING,N_ABN_03 FROM  R_1_STAT_RES
[/code]

Can I change the view like V_A_CALL_NO_AGG without changing the table like R_1_STAT_RES?

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7641
  • Karma: 56330
Re: Can I modify the view of ETL DB?
« Reply #1 on: November 03, 2022, 11:37:31 AM »
Why would you like to edit those views manually?
Those are created and maintained by what you do on DMA.


Offline cmpark

  • Newbie
  • *
  • Posts: 21
  • Karma: 0
Re: Can I modify the view of ETL DB?
« Reply #2 on: November 21, 2022, 06:23:57 AM »
You're right.
Without changing the original view, we created a completely new view. Thank you.