Search results for query: *

well, it depends on somany things, 1. check your indexes on tables 2. size of the data (if you really have heavy data we cannot do anything) 3. your network traffic. first you analyse the data. because some time it is reasonable even if it takes long to load Kishore MCDBA

what is the grain of your fact table, if your grain is the lowest i mean if it is at item level, you can add Misc. Charges and Freight Charges to the fact table, you no need to include Misc. Charges and Freight Charges in the dimension as it may give you problem if you want to use the same...

what sessions are you talking about? which tools are you using? can you pass more informtaion??? Kishore MCDBA

select * from dba_jobs_running if you do not want to run any job just remove job or schedule it with different interval Kishore MCDBA

is yoru transaction date is same as yoru payment date? or do you have separate payment date? if it is same why dont you select the max payement date group by customer??? Kishore MCDBA

hi david, the list of the KPI's completely depends on the domain of your datawarehouse, so do you mind telling something about your datawarehouse so that we can discuss about the possible KPI's for your datawarehouse. Kishore MCDBA

well here is another idea, but i am not sure if it works, you can add a loadingDate column to your target table and just load in the new snapshot of data into the table with new loading date when ever you load the data. but if you are going to get large amount of data, the table size may grow...

Well actually the file is not copied to the local PC, the local PC just works as the mediator to copy the file, and all the resource of your local PC will be used to copy the files, as memory, and virutal memory. Kishore MCDBA

may i know what kind of mappings you talking about between databases? is it direct? Kishore MCDBA

yeah thats the right idea, if the data in every record is of same length in that particular column you can define it as char, and if it is not same define it as varchar, because char always replaces space if there is no character in the record, if you are going to enter two characters for a...

well, i really dont have any idea about hash,MD5,SHA-1 all these terms looks new to me, do you people mine giving me some links to refer to this? Kishore MCDBA

well why dont you encrypt and decrypt the password in front end, and store and encrypted password in the database, Kishore MCDBA

well DWMaster, i am sorry i am not sure whether you can use microsoft indexing service object with PHP or not, Kishore MCDBA

yes it is possible to do with php, PHP and ASP both are same, but different providers, but the concept is same, both are used to created serverside scripting which redirects HTML code to client. Kishore MCDBA

in dimensional model, all the column names must be descriptive coz the column names will be used as a headers/titles in the reports generated by any OLAP tool, so normally it should have only one name either logically or physically. by the way in 4.1 where did you found the dimensional...

which version of ErWin you are using? Kishore MCDBA

well in this case you can alter your second table... like instead of having seperate column for each datatype just add one column datatype and enter your datatypes as the records so your columns in second table will be, ID,FieldID,DataValue,DataType 1 1 Doe varchar 2...

well, why are you using 3 seperate columns in your second tables for each data type? you can modify your second table to have only 3 coulmns( ID,FieldID,Value) insert ages also in varchar format, i dont think so you will be having some difficulties in handling integers saved in varchar. just you...

well,i dont think so you can do it, if you need some space any way it is holiday in the middle, so just try to compress other files on that disk, so that you can find enough space Kishore MCDBA

yup you dont need any datawarehouse concepts, all you are looking for is the document management, to set the privilizes you need to use database, and for indexing purpose just use Microsoft index service, using index service you can even generate a word index. so your work will be done quickly...