Author's posts
Dec 10
Export a table into csv format
Here is an example to export data from MySQL into CSV File Format. SELECT * INTO OUTFILE ‘/tmp/file_name.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘n’ FROM table_name;
Permanent link to this article: https://blog.openshell.in/2010/12/export-a-table-into-csv-format/
Dec 10
Fields Other than the PK Need to be Indexed
The Table Primary Key (PK) is automatically an index. Indexes should be used whenever a relationship needs to be established between two tables using a field other than the PK E.g. both fields included in the ON table1.field1=table2.field3 clause. Making both fields indexes allows MySQL to JOIN the two tables much more efficiently and much …
Permanent link to this article: https://blog.openshell.in/2010/12/fields-other-than-the-pk-need-to-be-indexed/
Dec 08
ETL Concepts
Extraction, Transformation and Loading (ETL) SAP NetWeaver BI offers flexible means for integrating data from various sources. Depending on the data warehousing strategy for your application scenario, you can extract the data from the source and load it into the SAP NetWeaver BI system or directly access the data in the source without storing it …
Permanent link to this article: https://blog.openshell.in/2010/12/etl-concepts/
Dec 06
Integration, Storage and Management of Data
Comprehensive, meaningful data analyses are only possible if the datasets are bundled into a business query and integrated. These datasets can have different formats and sources. The data warehouse is therefore the basis for a business intelligence solution. Enterprise data is collected centrally in the Enterprise Data Warehouse of SAP NetWeaver BI. The data is …
Permanent link to this article: https://blog.openshell.in/2010/12/integration-storage-and-management-of-data/
Dec 06
Tips for using jQuery
Find if something is hidden: We use .hide(), .show() methods in jquery to change the visibility of an element. Use following code to check the whether an element is visible or not. if($(element).is(“:visible”) == “true”) { //The element is Visible } Center an element on the Screen: To make align the element to center. jQuery.fn.center …
Permanent link to this article: https://blog.openshell.in/2010/12/tips-for-using-jquery/
Dec 06
MNP–Mobile Number Portability
INTRODUCTION Mobile Number portability (MNP) enables mobile subscribers to change their service providers or their location without having to change their existing phone numbers. If the subscribers are not satisfied with the services of their service provider, they can change their service provider while retaining the existing phone number. This infuses competition among service providers …
Permanent link to this article: https://blog.openshell.in/2010/12/mnp-mobile-number-portability/
Dec 04
How do I find out If Running Kernel Is 32 Or 64 Bit?
Target Audience: Beginners of Linux/Unix Users Many beginners of Linux/Unix users might struggle or uncertain when they download softwares for Linux/Unix to choose correct software according to its kernel ie. 32 bit or 64 bit. The uname command gives you the solution. Execute the following command in terminal: $ uname -a If the result contains …
Permanent link to this article: https://blog.openshell.in/2010/12/how-do-i-find-out-if-running-kernel-is-32-or-64-bit/
Dec 03
Using find command in linux
Using find command in linux find is a powerful command in linux. If u understand it then u can do most thing using it. but in this post i am not going to teach the full power of it but some basic usage. This is a simple one finding any .txt file in the home …
Permanent link to this article: https://blog.openshell.in/2010/12/using-find-command-in-linux/
Dec 03
5 CSS tricks you may not know
Using multiple classes together Usually attributes are assigned just one class, but this doesn’t mean that that’s all you’re allowed. You can actually assign as many classes as you like. For example: <div class=”class1 class2″></div> The class names are separates by a space. So that means “class1” and “class2” calls up the rules assigned to …
Permanent link to this article: https://blog.openshell.in/2010/12/5-css-tricks-you-may-not-know/
Dec 03
Get your free personal cloud -Ubuntu One
Introduction to Ubuntu One: Ubuntu One is a personal cloud for everyone. It’s just like syncing files, notes and contacts. You can access your contacts, notes or bookmarks from any computer or the web. The mind blowing thing in it is you can enjoy accessing your favorite music or stuff from a your iPhone and …
Permanent link to this article: https://blog.openshell.in/2010/12/get-your-free-personal-cloud-ubuntu-one/