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?
RE: Any one help and answer me for the following quest...
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
RE: Any one help and answer me for the following quest...
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
