RG 1. I don't recognize Ab Initio. 2. For Unix scripting, there are several alternatives. You should first decide what you should learn (this list can help), before you spend a lot of time learning it. For example, I wasted a lot of time learning csh only to find it isn't a very good scripting language. Does your company have any standards (for scripting, that is)? I would normally recommend ksh, but if you want something that will run on Windoes as well, you may want to consider Perl. This ties to your question #3. The appropriate tool(s) will vary by DW, depending on the needs. 3. Oh yeah, really different. It starts with the mindset. If you are a normalization bigot, you are in trouble. I find warehouses are much more different from each other that OLTP systems are different. Therefore it is very hard to create simple rules to follow. Are you designing the DW or just working on a DW that someone else designed?
Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, March 19, 2003 8:19 AM To: Multiple recipients of list ORACLE-L 1. Has anyone ever used Ab Initio? Is it some kind of data conversion tool? What is the the learning curve on it? Is there online documentation and do they have a freeware version to download? I want to learn it. Dont want to use it for development. 2. What is a good Unix scripting book for Oracle Developers? Dont need a Using Oracle as a DBA on Unix. Just one on basic scripting. My Unix skills are weak and I want to improve them. I have Redhat at home. What should I concentrate on? 3. In theory I know the difference between a datawarehouse and an OLTP, but as a developer is the work really that different? I understand star schemas etc... Just need to know how different the work is. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
