I have a BTEQ script here (something like an PL SQL ) for Teradata.
All that i have to do is convert this script into a server Job.
If u see thier are 3 tables user and the forth table where i will do the final insert. How can i do this ? like what all stages i need and which stage should be associted to which stage.
Thanks In Advance
Code: Select all
INSERT INTO CBSS_ETL.ACCOUNT
SELECT CAST(ACT_SVC_ORD_EFFV_DT AS TIMESTAMP)
,ACT_CUST_ACCT_NO
,ACT_BILL_PHONE_NBR
,ACT_CUSTOMER_NAME
,ACT_S_FULLCITY
,ACT_S_STATE_CODE
,ACT_S_ZIP_CD_PLUS_4
,SUBSTR((CASE
WHEN B.LOC_ID IS NULL
THEN ACT_B_FULLCITY
ELSE B.B_CITY
END),1,13) AS ACT_B_FULLCITY
,(CASE
WHEN B.LOC_ID IS NULL
THEN ACT_B_STATE_CODE
ELSE B_STATE
END) AS ACT_B_STATE
,(CASE
WHEN B.LOC_ID IS NULL
THEN ACT_B_ZIP_CD_PLUS_4
ELSE B_ZIP
END) AS ACT_B_ZIP_CD_PLUS_4
,CAST(ACT_OLD_CRB_MSD AS TIMESTAMP)
,ACT_TYPE_OF_ACCOUNT
,ACT_GRD_OF_SERVICE
,ACT_SLS_AREA_CD
,ACT_SIC_CODE
,ACT_CRED_RISK_CD
,ACT_NON_PUB_LIST_CD
,ACT_AMT_SIGN
,ACT_CUR_BILL_CHG
,CAST(ACT_EXTRACT_DATE AS TIMESTAMP)
,ACT_SERVICE_ADDR
,SUBSTR((CASE
WHEN B.LOC_ID IS NULL
THEN ACT_BILLING_ADDR
ELSE B.B_ADDR
END),1,65) AS ACT_BILLING_ADDR
,LEGACY_SYSTEM_ID
,CAST(CURRENT_TIMESTAMP AS TIMESTAMP)
,COALESCE(LOSS_TYPE,' ') LOSS_TYPE
FROM CBSS_ETL.WB_ACCOUNT_FEEDER A
LEFT OUTER JOIN CBSS_ETL.WB_LOCATION_LOOKUP B
ON A.ACT_CUST_ACCT_NO = B.LEGCAN
WHERE A.ACT_CUST_ACCT_NO NOT IN (SELECT DISTINCT ACT_CUST_ACCT_NO FROM CBSS_ETL.ACCOUNT);