Hi,
I have created a campaign using the new subject in Information Map.
subject 1: customers
subject 2: policy+customer
the join between the 2 subject is complex, but the key for the subject 2 is based on 3 fields.
when trying to run a test sql query in information map I can see exactly what I was expecting to:
PROC SQL Outobs=100;
Create table WORK.%RESULT_TABLE_NAME% as
SELECT DISTINCT
table1.NK_IND_AGMT_ID AS DIR_2 LABEL='Nk Ind Agmt Id' FORMAT=$100.,
table0.IDENTIFICATION_DOC_NUMBER AS DIR_3 LABEL='Identification Doc Number' FORMAT=$50.
FROM
MACUST.DIM_SC_MI_ID_CUSTOMER_PANEL_CU table0 Inner join DWH.CV4_MVW table1 on ( (table0.IDENTIFICATION_DOC_NUMBER = table1.TZ)
AND table1.LOOKUP_TZ = table1.TZ
AND table1.LOOKUP_ID_DOC_TYPE = table1.ID_DOC_TYPE_CODE )
GROUP BY
1,
2;
quit;
but when exporting the data to a table I can see that fields are empty, so I trying to query in oracle sql the same query the information map gave me, and it givven me the fields and not returning null. which is exactly what I was expecting to.
Why the CI is not doing the same connections and joins like the info map query?
the export I have is only export the keys (level id) from both subjects.
thanks