Data Warehousing - Any one help and answer me for the following question?Question : One employee is working in three d

GeekInterview.com > Interview Questions > Data Warehousing

Go To First | Previous Question | Next Question

Data Warehousing | Question 12 of 92

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?

Total Answers and Comments: 3

Last Update: May 06, 2006 Asked by: palani

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

April 27, 2006 05:51:46

Vikas Mane

RE: Any one help and answer me for the following quest...

Hi,

Time dependent info object will solve your problem.

Regards,

Vikas Mane

Is this answer useful? Yes | No

May 02, 2006 08:28:13

sithu

Member Since: March 2006 Contribution: 46

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

Cheers,

Sithu, sithusithu@hotmail.com

Is this answer useful? Yes | No

May 06, 2006 00:16:36

shaik

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

Is this answer useful? Yes | No

Go To Top