Related Posts
Hi Guys,
Please Advice, TIA.
Additional Posts in Data & Analytics Consultants
What’s EY DnA tech stack? EY
It's an "enhanced workflow"
Why are you in data?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
SELECT
A.TRANS_MSTR_KEY,
A.DT_SKEY,
A.TM_SKEY,
A.STORE_KEY,
A.TRANS_NBR,
A.CUST_KEY,
A.TRANS_TYP_KEY,
A.SALE_AMT,
B.TRANS_LNK_KEY,
B.PRODUCT_KEY,
C.STORE_ID,
C.CITY_NM,
C.POSTAL_CD,
C.STATE_NM,
D.PRDCT_DESC,
D.PRDCT_CD,
D.DEPT_NM,
E.TRANS_TYP_ID,
F.SUBSCRIBER_ID,
F.EM_DT
FROM "xxxx"."xxxx"."TableName"A
LEFT OUTER JOIN "xxxx"."xxxx"."TableName"B
ON A.TRANS_MSTR_KEY = B.TRANS_MSTR_KEY
LEFT OUTER JOIN "xxxx"."xxxx"."TableName"C
ON A.STORE_KEY = C.STORE_KEY
LEFT OUTER JOIN "xxxx"."xxxx"."TableName"D
ON B.PRODUCT_KEY = D.PRODUCT_KEY
LEFT OUTER JOIN "xxxx"."xxxx"."TableName"E
ON A.TRANS_TYP_KEY = E.TRANS_TYP_KEY
LEFT OUTER JOIN "xxxx"."xxxx"."TableName"F
ON A.CUST_KEY = F.CUST_KEY
WHERE E.TRANS_TYP_ID IN ('01','02')
https://tinyurl.com/vrulv2x
You should've done this. Will help you a lot in your career
This isn’t going to work
Split up into smaller queries, otherwise use limit to run on subset and profile your code
Can you give an example of that. Fairly new to using SQL so not too sure how to execute this
???
Side question... would Domo be better to use for such large data?