Hi
I am a student currently working in a data warehousing project .my problem 
are as follows. 
1. I have one flat file & one sql data base table, I want to extract 
conditional data from those two to a destination sql table without using a 
temp table. i.How can i do this job?
                
            ii.	How can we do this by applying Lookups in SQL Server 2000?

2.	How to implement ?Surrogate keys? for DTS (Data transmission 
Services ) in SQL Server 2000.



3.	How are additive and non-additive measures are defined in analysis 
services?

4.	How are numeric and non-numeric measures are defined in analysis 
services?

If anybody have any ideas regarding my above problem please