Link DOJ and Salary Date to Master Calender

[vikasmahajan]

Hii

I have problem with master calender how do I link DOJ date of join of Employee Master and Salary Date with Calender Also I want to Link EMPID and EMPID Of salary table how to achieve the same.

Please find attached data model

Vikas

[MK_QSL]

Employee Table must be joined by Employee ID with Salary table...

Create DOJ as DATE and 'DOJ' as Flag in EmployeeTable

Create [Salary Date] as Date and 'SalaryDate' as Flag in Salary Table...

Now create a Mater Calendar with DATE field...

You will get a Synthetic Key due to the two common field in both tables... DATE and Flag..

Create a link table or use concatenation method to remove the key..

[vikasmahajan]

Dear Mr.Manish ,

Many Thanks for valuable Input Please can you guide me how to remove syn key  as per your instruction I have created link got syn key.

Your expert guidance is required.

Vikas

[MK_QSL]

Provide your sample apps... Would work on the same and come back to you...

[vikasmahajan]

Please find attached demo apps I have created Please help me to achieve the same after your solution I shall try this logic on Live

Thanks

Vikas

[MK_QSL]

I have done it by using IntervalMatch... If your requirement doesn't fulfilled, let me know, will try with link table...

[vikasmahajan]

Dear Manish,

in live scenario  following  lines held script and creating lot or records  and creating performance issues

Left Join (EMP) Load PAY_DATE Resident SALARY;

Drop Field PAY_DATE From SALARY;

Please you give me using Link approach.

Vikas

[MK_QSL · Accepted solution]

FYI

[vikasmahajan]

Dear Manish,

After checking  this in live I got solution which I am looking for

Many Thanks

Vikas

[vikasmahajan]

Dear Manish,

Due to your support and expert guide lines I able to complete Hr Module , I really appreciate your help

Thanking once again.

Good Day

Vikas