If you are a Bones fan, then you gotta see the A&P Professor for tips, content updates, teaching tools, resource links, and conversations related to teaching and learning human anatomy and physiology. The author is as an anatomy & physiology professor for several decades and has tons of information on A&P. The blog was started an year ago and has evolved as a one stop shop for human anatomy and physiology since then. Since the author writes A&P textbooks, ancillaries, and reference works, this blog is kind of a wikipedia on this subject. Note that the auther is also a President Emeritus of the Human Anatomy and Physiology Society (HAPS) and a founder of HAPS Institute, a continuing education program for A&P professors. They have several blogs and websites related to teaching and learning.
Some of the highlighting features of this blog are:
** Easily plugs into your facebook friends adding more visibility in social space
** Detail review of new books and thesis
** FREE newsletter to keep you updated on a periodic basis
** Ability to link to podcasts and listen at your own leisure
** Connect your blog using Google friend connect
** Subscription feature on other popular RSS readers
** Purchase the relevant books within a few clicks right from their amazon store
** Blog available in multiple languages using the translation tool
** FREE videos on learning human anatomy and physiology
Besides this you will find several articles on The A&P Student, Electronic Professor
,A&P Student Library, HAPS Institute (short graduate courses) and links to industry specific associations like
1. The American Physiological Society
2. Human Anatomy and Physiology Society
3. American Association of Anatomists
Tuesday, May 12, 2009
Old ETL tools versus new ETL tools
After all, how could start-ups with a fraction of the resources of an IBM Corp., Oracle Corp., or SAP -- not to mention an Informatica Corp., Microsoft Corp., or SAS Institute Inc. -- hope to compete?
Something close to the opposite happened. Innovation might not exactly be thriving in the DI segment, but it's far from moribund. In the last year alone, upstart DI players such as Expressor Software Corp. and Talend arrived, touting two decidedly dissimilar -- but characteristically "next-gen" -- takes on DI. Their marketing pitches might differ dramatically, but both Expressor and Talend tout a flavor of "fresh" DI -- offerings they claim are faster, more flexible, and less "legacy" than established products.
According to Expressor officials, for example, the DI suites marketed by IBM, Informatica, and other heavyweights are powered by aging or "legacy" ETL technology that doesn't scale as well or which isn't as "smart" as Expressor's stuff.
"Sure, some of this stuff was created 15 years ago or 20 years ago -- but so was EAI. So was so much of the technology we use. Everything that's in the market now started a long time ago and evolved forward," he maintains. "It isn't a question of age. Just because something is built on older technology -- and we've done a lot of [modernization] work on our own with that product [InfoSphere Information Server] -- doesn't mean it's inefficient."
Something close to the opposite happened. Innovation might not exactly be thriving in the DI segment, but it's far from moribund. In the last year alone, upstart DI players such as Expressor Software Corp. and Talend arrived, touting two decidedly dissimilar -- but characteristically "next-gen" -- takes on DI. Their marketing pitches might differ dramatically, but both Expressor and Talend tout a flavor of "fresh" DI -- offerings they claim are faster, more flexible, and less "legacy" than established products.
According to Expressor officials, for example, the DI suites marketed by IBM, Informatica, and other heavyweights are powered by aging or "legacy" ETL technology that doesn't scale as well or which isn't as "smart" as Expressor's stuff.
"Sure, some of this stuff was created 15 years ago or 20 years ago -- but so was EAI. So was so much of the technology we use. Everything that's in the market now started a long time ago and evolved forward," he maintains. "It isn't a question of age. Just because something is built on older technology -- and we've done a lot of [modernization] work on our own with that product [InfoSphere Information Server] -- doesn't mean it's inefficient."
Tuesday, December 9, 2008
Outdoor shopping for ETL
Here is the spec that I liked about Luminox.
Size: 43mm
Case: Fiberglass
Bezel: Aluminum
Dial: Black w/Date
Band: Nylon/Velcro Strap
Movement: Swiss
Submersible: 200M
Illumination: Tritium
Special Features: Mineral Crystal
So get out there for safe adventuring as you know that having the correct gear could mean the difference between having an unforgettable outdoor adventure or experiencing a life-threatening event. With so many years of collective travel experience, the team is fully dedicated and prepared to assist you.
Whether camping in the highest elevations of the Sierras or backpacking through some of the greatest national parks, it is this passion and experience Sierra Adventure Team dedicates to sharing with you that you can get all you outdoor needs here at the one stop shop. Remember that Sierra Adventure Gear carries a large variety of brand names in outdoor gear such as Luminox and Dakota Watches, Maglite, Brunton, SOG, Gerber, Leatherman and Buck Knives at the lowest prices ever,
Informatica with NEC InfoFrame Solution Suite
NEC will offer Informatica’s PowerCenter as part of its NEC InfoFrame information management solution suite. Informatica has also been certified as an NEC alliances partner. Under the terms of the distribution agreement, PowerCenter will be marketed to NEC customers in Japan under the NEC brand and will be supported by an Informatica-dedicated NEC engineering team.
The NEC Alliances Program is comprised of a handful of the leading vendors in the industry. The NEC-Informatica partnership will allow NEC customers to leverage PowerCenter in concert with other components of the InfoFrame Data Coordinator Solution suite, including InfoFrame Documentum and InfoFrame DataBooster both aimed at large-scale data integration projects.
Informatica PowerCenter offers near-universal data integration capabilities and is the only data integration component of the InfoFrame solution suite.
The NEC Alliances Program is comprised of a handful of the leading vendors in the industry. The NEC-Informatica partnership will allow NEC customers to leverage PowerCenter in concert with other components of the InfoFrame Data Coordinator Solution suite, including InfoFrame Documentum and InfoFrame DataBooster both aimed at large-scale data integration projects.
Informatica PowerCenter offers near-universal data integration capabilities and is the only data integration component of the InfoFrame solution suite.
Tuesday, October 7, 2008
ETL based credit card processing service
What is ETL based credit card processing? Any credit card processing that leverages ETL platform can be categorized in this broad term of Free Payment Gateway. Now merchantacceptance offers $0 license fee and also $0 application and set up along with $0 programming free virtual terminal and direct deposit and online reporting services. This is where the ETL comes into picture. The accurate sales tracking is based on the strong ETL and datawarehouse platform it is based on. Customers can get free online shopping cart and also good news for AdWords customer who get free Google Adwords credit with free search engine submission to boost your sales through SEO. Most importantly they have been the pioneers in providing free customer service support with free payment gateway and free business software.
Monday, September 29, 2008
Whether to go for EAI or ETL
Factors for consideration in the decision include:
1. Costs of run-time processing and development.
2. Proprietary nature of source or target systems. A situation where the source system can only be accessed via screen scrapping because the file layouts and key structures are part of package and source is not available. In such cases neither ETL nor EAI will work and a solution might have to be developed on case to case basis.
3. The state of data and load-time window available to migrate data from source to target and vice versa which needs real-time movement of data.
4. Complexity and mapping of source and target systems by data elements and data quality in each system.
5. Skills of staff relative to EAI and ETL tools.
1. Costs of run-time processing and development.
2. Proprietary nature of source or target systems. A situation where the source system can only be accessed via screen scrapping because the file layouts and key structures are part of package and source is not available. In such cases neither ETL nor EAI will work and a solution might have to be developed on case to case basis.
3. The state of data and load-time window available to migrate data from source to target and vice versa which needs real-time movement of data.
4. Complexity and mapping of source and target systems by data elements and data quality in each system.
5. Skills of staff relative to EAI and ETL tools.
Friday, September 19, 2008
Delivering Asian Chat to your ETL blog
Asian Chat city has now arrived on a blog near you. Here where tons of Asian users from everywhere in the world join ETL chats and have fun for 100% free! Hop on your cam and show tons of people see you right from your ETL blog while you enjoy their video cam! You can signup for completely free account today and begin seeing and talking to all of the ETL users on this site today especially for increasing your ETL connections.
SCD 1 implementation in Datastage
Type 1 Slowly Changing Dimension data warehouse architecture applies when no history is kept in the database. The new, changed data simply overwrites old entries. This approach is used quite often with data which change over the time and it is caused by correcting data quality errors (misspells, data consolidations, trimming spaces, language specific characters). Type 1 SCD is easy to maintain and used mainly when losing the ability to track the old history is not an issue.
SCD 1 implementation in Datastage
The job described and depicted below shows how to implement SCD Type 1 in Datastage. It is one of many possible designs which can implement this dimension. The example is based on the customers load into a data warehouse.
Datastage SCD1 job design
The most important facts and stages of the CUST_SCD2 job processing:
There is a hashed file (Hash_NewCust) which handles a lookup of the new data coming from the text file.
A T001_Lookups transformer does a lookup into a hashed file and maps new and old values to separate columns. A T002 transformer updates old values with new ones without concerning about the overwritten data. SCD1 Transformer update old entries The database is updated in a target ODBC stage (with the 'update existing rows' update action)
SCD 1 implementation in Datastage
The job described and depicted below shows how to implement SCD Type 1 in Datastage. It is one of many possible designs which can implement this dimension. The example is based on the customers load into a data warehouse.
Datastage SCD1 job design
The most important facts and stages of the CUST_SCD2 job processing:
There is a hashed file (Hash_NewCust) which handles a lookup of the new data coming from the text file.
A T001_Lookups transformer does a lookup into a hashed file and maps new and old values to separate columns. A T002 transformer updates old values with new ones without concerning about the overwritten data. SCD1 Transformer update old entries The database is updated in a target ODBC stage (with the 'update existing rows' update action)
Jewish Men for ETL work
Jewish Men are hard to find for an ETL work, but why would you need Jewish men ? Not only you need Jewish men for dating but you can hook up with ETL developers also through jsingles.com and they have pride in offering a special dating service that offers 24/7 phone support, active chat, instant messaging, & much more. If your hunting for Jewish Men, then you've found it right here. You get the access to the biggest database right from you blog,and the quickest sites, & very active customer base from any dating site on the internet. Just take a look for the newest members who have recently joined near you from their IP address based location finder on the homepage.
Steps for generation of a SAS business datawarehouse
Please also be aware of the fact that SAS is very powerful and flexible system and the steps below can be done in many different ways. It is just one way to get the expected results.
- First step will be to read dimensions and populate sample dimensions data
- Then a fact table will be created.
- In the next step we will randomly generate transactions for the fact table with sales data for three years. To generate the numbers we will use SAS random number generators with uniform and random distributions.
- The final tasks will be to validate and extract generated data and feed the reporting application.
- First step will be to read dimensions and populate sample dimensions data
- Then a fact table will be created.
- In the next step we will randomly generate transactions for the fact table with sales data for three years. To generate the numbers we will use SAS random number generators with uniform and random distributions.
- The final tasks will be to validate and extract generated data and feed the reporting application.
Talk Reviews for African ETL
Now there is an easy way to write a website review for your African ETL work. I have never seen a site dedicated to reviews for any country specific ETL work. There are tons of top South African websites that are reviewed by fellow bloggers and give a deep insight on the strategies in ETL world and keep you on the top of the world in technology forefront. Good or bad, pleased or unpleased, happy or dissatisfied with service, come share your ETL experience with others working in African ETL field. So stop staring and start sharing at TalkReviews.com
Pentaho Data Integration - Kettle ETL tool
Kettle (K.E.T.T.L.E - Kettle ETTL Environment) has been recently aquired by the Pentaho group and renamed to Pentaho Data Integration. Kettle is a leading open source ETL application on the market. It is classified as an ETL tool, however the concept of classic ETL process (extract, transform, load) has been slightly modified in Kettle as it is composed of four elements, ETTL, which stands for:
Data extraction from source databases
Transport of the data
Data transformation
Loading of data into a data warehouse
Kettle is a set of tools and applications which allows data manipulations across multiple sources.
The main components of Pentaho Data Integration are:
Spoon - a graphical tool which make the design of an ETTL process transformations easy to create. It performs the typical data flow functions like reading, validating, refining, transforming, writing data to a variety of different data sources and destinations. Tranformations designed in Spoon can be run with Kettle Pan and Kitchen.
Pan - is an application dedicated to run data transformations designed in Spoon.
Chef - a tool to create jobs which automate the database update process in a complex way
Kitchen - it's an application which helps execute the jobs in a batch mode, usually using a schedule which makes it easy to start and control the ETL processing
Carte - a web server which allows remote monitoring of the running Pentaho Data Integration ETL processes through a web browser.
Data extraction from source databases
Transport of the data
Data transformation
Loading of data into a data warehouse
Kettle is a set of tools and applications which allows data manipulations across multiple sources.
The main components of Pentaho Data Integration are:
Spoon - a graphical tool which make the design of an ETTL process transformations easy to create. It performs the typical data flow functions like reading, validating, refining, transforming, writing data to a variety of different data sources and destinations. Tranformations designed in Spoon can be run with Kettle Pan and Kitchen.
Pan - is an application dedicated to run data transformations designed in Spoon.
Chef - a tool to create jobs which automate the database update process in a complex way
Kitchen - it's an application which helps execute the jobs in a batch mode, usually using a schedule which makes it easy to start and control the ETL processing
Carte - a web server which allows remote monitoring of the running Pentaho Data Integration ETL processes through a web browser.
Just talk reviews on talkreviews.com
Website Reviews are an essential element for perfect shopping experience. Especially when you are purchasing something online there is no way you can put complete trust in any site unless you hear real testimonials from other customers who have bought the same product and share their complete experience. Now talkreviews.com just talks about reviews and allows users to share their views through the online site review form. For example when I travel to NJ and want to stay at Doubletree Hotel Jersey City, I can easily get detail stats about it and also in several countries Hilton operates its Top Websites. Its a value add for giving a rich internet shopping experience.
Basics of Data Integration
The ETL process is also very often referred to as Data Integration process and ETL tool as a Data Integration platform. The terms closely related to and managed by ETL processes are: data migration, data management, data cleansing, data synchronization and data consolidation. The main goal of maintaining an ETL process in an organization is to migrate and transform data from the source OLTP systems to feed a data warehouse and form data marts. At present the most popular and widely used ETL tools and applications on the market are:
*IBM Websphere DataStage (Formerly known as Ascential DataStage and Ardent DataStage)
*Informatica PowerCenter
*Oracle Warehouse Builder
*Ab Initio
*Pentaho Data Integration - Kettle Project (open source ETL)
*SAS ETL studio
*Cognos Decisionstream
*Business Objects Data Integrator (BODI)
*Microsoft SQL Server Integration Services (SSIS)
*IBM Websphere DataStage (Formerly known as Ascential DataStage and Ardent DataStage)
*Informatica PowerCenter
*Oracle Warehouse Builder
*Ab Initio
*Pentaho Data Integration - Kettle Project (open source ETL)
*SAS ETL studio
*Cognos Decisionstream
*Business Objects Data Integrator (BODI)
*Microsoft SQL Server Integration Services (SSIS)
Monday, September 15, 2008
FREE cell phones for ETL developers
Have you been frustrated in choosing the right cellular deals just because they keep on changing every day ? Or you are the reader who does not read the news because the news keep changing? Well that was just a joke. But I found the website bestincellphones.com after I researched for Blackberry phones online. I wished I had found this website earlier before signining a contract with my current cell phone company. Well my current contract is with Sprint phones and they have a 1 year contract which I was not comfortable to sign with. So the website bestincellphones.com that I searched showed me deals not only with sprint but also Verizon cell phones that did not have any contract and you can get a cell phone for free. That is really amazing. Can you believe a free phone with no contract? Well you have to regularly check for this site for these types of deals because they keep on changing every day and one fine day you miss the deal of your life time. I always keep an eye on at&t cell phones because my dream is to get a free iPhone with no contract and that I have been waiting for the past one year. Hopefully one day this site will offer me the best deal if we as ETL developers unite together and appeal to the company to come up with such a deal for us. In any event, I will keep a close eye and also I forgot to mention that they have TMobile phones, as my girlfriend has a tmobile that she regrets not buying from this site! So dont miss you chance of amazing phone deals of your lifetime.
Benefits of Jitterbit Integration Solution
Jitterbit Integration Solution is the Leading Open Source Integration Platform that combines intuitive integration design with robust functionality and scalable performance. Jitterbit is designed to handle the most complex integration challenges between legacy, enterprise and On-Demand applications, including Business Process Fusion, ETL, SaaS, and SOA. The Jitterbit Solution enables organizations to unite their independent applications and data in record time and for the lowest total cost of ownership in the industry.
Rapid Results:
Start integrating in minutes!
Graphical drag-n-drop mapping without custom code
100% standards-based communication
Out-of-the-box connections for major enterprise applications, all major databases, flat-files, Web Services, and messaging systems
Pre-built integrations (Jitterpaks) available at the Trading Post
Robust & Scalable
Multi-threaded architecture
Optimized for Windows, Linux and Solaris
Advanced caching for improved performance
Easy Integration Management:
Complete visibility into transactions
Schedule processes and automate success/failure operations
Proactive alerting of data and connectivity errors
Role-based access privileges
Cost Effective:
No software licenses
No appliance hardware to buy
Low annual support subscription pricing
Up to 90% lower operating costs vs. proprietary alternatives
Rapid Results:
Start integrating in minutes!
Graphical drag-n-drop mapping without custom code
100% standards-based communication
Out-of-the-box connections for major enterprise applications, all major databases, flat-files, Web Services, and messaging systems
Pre-built integrations (Jitterpaks) available at the Trading Post
Robust & Scalable
Multi-threaded architecture
Optimized for Windows, Linux and Solaris
Advanced caching for improved performance
Easy Integration Management:
Complete visibility into transactions
Schedule processes and automate success/failure operations
Proactive alerting of data and connectivity errors
Role-based access privileges
Cost Effective:
No software licenses
No appliance hardware to buy
Low annual support subscription pricing
Up to 90% lower operating costs vs. proprietary alternatives
Instantly connect with Asian ETL developers
Majority of ETL developers are Asian Singles and some ETL blogs help with matching for someone like you. All you need to do is signup on asianmatching.com and instantly connect to thousands of Asian ETL developers. Even this is helpful for HR guys. The website has many features that other dating sites do not have. Joining only takes a minute. Joining the community will allow you to better match you with other members although you can search without becoming a member.
Is cloud computing an integrated ETL function ?
Cloud computing does nothing to solve tricky data integration problems that companies may be wrestling with. Cloud-based systems do not do the hard integration work - that's still up to the enterprise. If an organization chooses Salesforce.com CRM on demand instead of SAP or Oracle CRM deployed within their firewall, does anything really change? Yes, there's no doubt that there are potential benefits as far as getting CRM up and running goes, but then what? In the enterprises I've worked with, the bulk of the projects were not about implementing some new vendor package. Some of that was always occurring, but there was plenty more that was about integration, enhancements, and other development activities.
Black Women with ETL background
Black Women have a deep ETL background from the comments that we get on this blog and now I found the site blacksene.com where you can always find active Singles, with many people in your neighborhood..It is an online singles and personals site, featuring some of the amazing members. If your looking for Black Women, then you just found it on this blog right here. The site also features the largest database,the speediest sites, and the most active users from any dating service on line.
Coming Soon: Open Source ETL Conversion Tool
Last count their are about a dozen ETL vendors in the market. This includes Informatica, IBM, Talend, Apatar, Ab Initio, Expressor-Software, Business Objects/SAP, Oracle, Microsoft, Cognos/IBM, Pentaho (Kettle), SAS, Enhydra Octopus and probably more that I'm missing. The challenge? Nothing that you do in each one of these products is portable to migrate to another ETL tool. I can see why this is the case. It's about lock-in. Once you build an integration using an ETL tool, depending on the complexity, it is very difficult to swap out one for another. This certainly keeps the prices up in the proprietary vendor community. ASP's in this space are probably around 200K or more. For all the years that these products have been in the market, its amazing that nothing has been pursued to produce an ETL process standard like what has been in with BPEL (Business Process Execution Language). I guess my entrepreneurial instincts lean towards thoughts of creating an open source ETL Conversion tool for the market. Although very difficult to build, thus a barrier to entry, I suppose that building it as an open source solution might be the best approach. No one really owns it and it would benefit customers as they will have an option to jump out of one ETL product to another without feeling locked in forever.
Subscribe to:
Posts (Atom)