Interval table synthetic key

[Prabhu1204]

Interval Table:

when implementing below interval match.. It forms many synthetic keys and really concerned in adding the code table fields to the Ca lender table. The data rows increases in calender table.. Is ther any other way ?

There is no direct link between the code table and calendar table.

Calendar_table:
LEFT KEEP (FACT) LOAD DATE_KEY As DT_KEY,
Date(CAL_DATE) As (calendar_date)

FROM $(Path)DATES.qvd (qvd);

code:
LEFT KEEP (FACT) LOAD CD,
Dept_CD,
Class,
startdate,
enddate
FROM $(Path)Dates.xls

IntervalTable:
LEFT JOIN (code)
IntervalMatch(calendar_date)
LOAD startdate,enddate
RESIDENT code;

LEFT JOIN (calendar_table)
LOAD *
RESIDENT code;
DROP TABLE code;

[Prabhu1204]

Yes, i understand.. 

all my linking filed from fact tables are getting dotted lines

[Prabhu1204]

 excecuting this "AutoNumber(startdate& '|' & enddate) AS %StartEnd " i am getting circular reference loop

[petter · Accepted solution]

Yes - you have already connected both the Code and the Calendar_table to the FACT table so connecting Code to Calendar_table with Interval_table will create a loop. 

You have to remove either the Code to FACT connection or the Calendar_table to FACT connection to get rid of the circular reference.

[Prabhu1204]

Hello ,

When i tried to remove the code connection from fact table, i am not getting the fields selected available in the codes table .

[Prabhu1204]

Should i pull all the fileds from the code table to the interval table ?