Wanna help in Datawarehousing Programming Databases by arnab0034 Hi all, I am totally new in Datawarehousing stream. Can anybody help me providing some information about Ab Initio(some links or some pdfs) so that I can start off. Need help pls Programming Databases by haria_kishore Hello guys Actually I am new to the world of datawarehousing. In fact today is my third day. Actually I am … Wanna help Programming Databases by arnab0034 Hi, I am in Java & wanna switch to Datawarehousing stream. I've knowledge in Informatica & Business Objects 6.5. Can anybody suggest me how can I switch. crm Programming Computer Science by amanda2009 I have to create a project on CRM. Can anyone tell me how to go about it. Means designing and datawarehousing. Please reply, i dont have much time. how to find out this xsl for this xml? Programming Software Development by jeraldmuthu …; </xsl:stylesheet> I'm new to Business Inteligence(Datawarehousing), in our company already they are created product based on… idea on software technologies Programming Software Development by maredinaveen hello everyone ,i am new to daniweb club i am so much happy to meet you here i am an MCA fresher i have confusion to get train in software technologies so please help and advise which technology presently in market .i am planing for datawarehousing please give your openions and advises on this technology Re: Help on General Best Practices for Table/Database Design Programming Databases by pty [QUOTE=tinamary;386889]The best design for any database is normalization[/QUOTE] In this case yes, normalisation is correct. Your statement though is not entirely true; especially when datawarehousing and complex searches come into play. Re: Career dilemma - ASP.NET or DW/BI career Community Center by xkey … save my soul and share me your thoughts.:-/[/QUOTE] The Datawarehousing/Bus Intell would serve you better in the longrun and… Re: IT field Community Center by Suhanti By fluke, I got into IT Analytics with some basic datawarehousing knowledge and SQL coding. Please please tell me, how to … Datawarehousing Help Programming Databases by haria_kishore Hi everyone can anyone please help me to define the dimension table for EMPLOYEE I need to design the dimensional table with the hierarchy starting with Board of Directors(which is sub categorised into Staff for Board of Directors which again is subcategorize into Technical, Administrative and Accounts) Then we have separate 3 departments … Re: Datawarehousing Help Programming Databases by autocrat erm, not 100% sure what exactly you want..... yet can't you create a table with the headings of.... Title Department/Division Position Type First Name Last Name Xtra Dtls ....then have a select list for each of these.... "Type" would have Perm/Temp, "Department/Division" would have Tech/Admin/Acc and so on. … Re: Datawarehousing Help Programming Databases by haria_kishore I want to create a dimension table which contains the hierarchy for data. What u specified is already created. the user enters the data into the excel sheets which will be read by an application and data is posted into an operational database My work is to check all the data and post those data into DW which will be used for reporting and … Re: Datawarehousing Help Programming Databases by autocrat ahy, I think this might help then.... not precisely for your means, yet has the rough details you want (I think) [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdw/createdw_7xnp.asp[/url] Re: Need help pls Programming Databases by autocrat Sorry... I can't help... but if I could ask some details.... what is data warehousing? Operational DB.... the DB a company uses during the day? Warehouse DB.... somewhere you put backups? Re: Need help pls Programming Databases by haria_kishore Actually datawarehouse is nothing but a huge database(or just a database) with contains summarized information,historical data and is mainly used to create reports based on the data available. OD is an operational database which is used to store transactional data(all the data intergity and data validation is done in OD). Once the data is … Re: Need help pls Programming Databases by autocrat well.... the cheating method would be to copy the structure from the OD DB, then alter the permissions....turn of edit, update and append, then generate the various reports....like I said, cheating! The design approach relies on the original too! You need to know the names of every field and table, and probably most of the coding/script that is… Re: Need help pls Programming Databases by haria_kishore Thanks buddy for ur help Ur suggestion atleast gave me a clear picture of what to do Actually what i thought was that we already created the master and child tables in the OD DB. So when creating facts and dimensions in DW, why not use the master tables of OD as facts and child tables as dimensions What do u suggest mate? Re: Need help pls Programming Databases by autocrat That would make refrencing much easier, particularly if you ensure search capabilities and queries geared towards that design mode....... To be honest, there is nothing stopping you from designing the DW DB completely differently from the OD DB, so long as their output files can be read .... so either they need to output in you format, or you … Re: crm Programming Computer Science by Salem [url]http://www.daniweb.com/forums/announcement14-2.html[/url] [url]http://www.catb.org/~esr/faqs/smart-questions.html#urgent[/url] Re: crm Programming Computer Science by kylegetson I strongly advise against building your own in a hurry, especially if you plan on putting a lot of important data in it. There are plenty of open source CRM systems out there that will probably accomplish your goals. There are also paid systems that will handle everything for you, except data entry. Building your own is going to take a lot of work… Re: crm Programming Computer Science by amanda2009 Thanx for your advice. I know that it is very time consuming and cumbersome to create a new crm project but i m not intented to create a complete crm application. I want to learn how data warehousing and data mining are done in crm. So i will be concentrating on that part only. Can you please tell me how it is done in a crm application? I had gone … Re: idea on software technologies Programming Software Development by hkwhitten Hello - Your question is pretty general. Are you interested specifically in Microsoft technologies? If so, here's a rather old but comprehensive overview: http://msdn.microsoft.com/en-us/library/aa226252(v=sql.70).aspx If you are considering open source technologies, you might take a look at what people are doing with Hadoop from Apache: http://…