Any one help and answer me for the following question?Question : One employee is working in three different locations. Frequently, the employee changes his work location. Using n-n relationship, how to identify the employee's current location? or how to draw fact table and dimension tables relationship for this concept?

Vikas Mane

• Apr 27th, 2006

 

Hi,

Time dependent info object will solve your problem.

Regards,

Vikas Mane

sithu

 Profile Answers by sithu 

• May 2nd, 2006

 

Hi Palani,

you define a object(flag) to find out the EMP location on for a particular date/time{he could not able to be in two place at one time }, with use of your time Dimesion write a condition, you will get the Resule

Cheers,

Sithu, sithusithu@hotmail.com

shaik

• May 6th, 2006

 

Take a union transformation and take three working dimensions of three different location  and filter the data and draw a dimension and fact according to specification