Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi all,
How to create data modeling with star schema .pfa
 
					
				
		
 prieper
		
			prieper
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Would you please generalize your problem, think that not everyone is willing to download 15MB and write an application for it ...
Peter
 HirisH_V7
		
			HirisH_V7
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Did You tried all tables as Left Join between them !
Whats the issue !
 
					
				
		
Actually am confused that what function I should apply on that as you see all attachments have same field but values are not same and I am trying to do star schema on it.
Only field safety xls is different and all fields also different.can you please suggest what will I have to do here.
 HirisH_V7
		
			HirisH_V7
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi ,
I loaded all of your files, Can you rename and justify the fields. Create one common key for every Table .
Check PFA
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
please post your current result together with one specific question.
thank you
regards
Marco
