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?

  • Interview Candidate
  • 3
  • 2304

Showing Answers 1 - 3 of 3 Answers

Vikas Mane

  • Apr 27th, 2006
 

Hi,

Time dependent info object will solve your problem.

Regards,

Vikas Mane

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions