<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-5328628232745164352</id><updated>2011-08-30T22:42:09.211-07:00</updated><category term='UNIX'/><category term='SED'/><category term='HP Touchpad'/><category term='AWK'/><category term='webOS'/><category term='PERL'/><category term='TERADATA'/><category term='MISC'/><title type='text'>AKT View</title><subtitle type='html'>my views</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>25</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-9052653743184925149</id><published>2011-08-29T23:42:00.000-07:00</published><updated>2011-08-30T22:42:09.226-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='webOS'/><category scheme='http://www.blogger.com/atom/ns#' term='HP Touchpad'/><title type='text'>How to install Preware on your HP Touchpad on Mac OS X</title><content type='html'>1) Enable developer mode on HP Touchpad, this can be done by typing &lt;span style="font-style:italic;"&gt;webos20090606&lt;/span&gt; in &lt;span style="font-style:italic;"&gt;"Just type"&lt;/span&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/-DrMAGM9r6dI/Tl0OXPAlG5I/AAAAAAAAAEo/HJzV-XmJxRw/s1600/aktview.blogspot.com1.png"&gt;&lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 240px;" src="http://1.bp.blogspot.com/-DrMAGM9r6dI/Tl0OXPAlG5I/AAAAAAAAAEo/HJzV-XmJxRw/s320/aktview.blogspot.com1.png" alt="" id="BLOGGER_PHOTO_ID_5646685300121213842" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;2) A new card opens which says developer mode, slide the toggle to on, you can set the password if you want.&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/-Sohrbv1GHlU/Tl0OeVfn4GI/AAAAAAAAAEw/bITePZ3i7JA/s1600/aktview.blogspot.com2.png"&gt;&lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 240px;" src="http://4.bp.blogspot.com/-Sohrbv1GHlU/Tl0OeVfn4GI/AAAAAAAAAEw/bITePZ3i7JA/s320/aktview.blogspot.com2.png" alt="" id="BLOGGER_PHOTO_ID_5646685422121115746" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;3) Now get your cable ready, and put your TP on a side&lt;br /&gt;&lt;br /&gt;4) Download the webOS Quick Install from &lt;a href="http://forums.precentral.net/canuck-coding/274461-webos-quick-install-v4-2-3-a.html"&gt;here&lt;/a&gt;, this is a jar file&lt;br /&gt;&lt;br /&gt;5) For Mac OS X, you may have to download the Novacom driver separately if you have any problem in above step, you can download it from &lt;a href="http://www.filesonic.com/file/1805669734/novacom-mac.tgz"&gt;here&lt;/a&gt; and install it&lt;br /&gt;&lt;br /&gt;6) Now connect your TP to your Mac, on the TP, click Close/Cancel when USB drive prompt shows up&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/-A9vAUgJGrwA/Tl0POPbfYtI/AAAAAAAAAFI/Pl-tecoLwbk/s1600/aktview.blogspot.com3.png"&gt;&lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 240px;" src="http://3.bp.blogspot.com/-A9vAUgJGrwA/Tl0POPbfYtI/AAAAAAAAAFI/Pl-tecoLwbk/s320/aktview.blogspot.com3.png" alt="" id="BLOGGER_PHOTO_ID_5646686245126890194" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;7) Now your TP should show up in the webOS quick installer. Next click on the globe icon on the right.&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/-q06cVl1Psn0/Tl0PABRSECI/AAAAAAAAAE4/aLDDpJpOMjY/s1600/aktview.blogspot.com4.png"&gt;&lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 216px;" src="http://2.bp.blogspot.com/-q06cVl1Psn0/Tl0PABRSECI/AAAAAAAAAE4/aLDDpJpOMjY/s320/aktview.blogspot.com4.png" alt="" id="BLOGGER_PHOTO_ID_5646686000807809058" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;8) Select Preware from the list and click install.&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/-TwsX1kzenzM/Tl0QWDvqiwI/AAAAAAAAAFQ/mJo6ugYvCEE/s1600/aktview.blogspot.com5.png"&gt;&lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 241px;" src="http://2.bp.blogspot.com/-TwsX1kzenzM/Tl0QWDvqiwI/AAAAAAAAAFQ/mJo6ugYvCEE/s320/aktview.blogspot.com5.png" alt="" id="BLOGGER_PHOTO_ID_5646687478940863234" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;That's it Preware will show up in the downloads tab on your HP Touchpad.&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/-Jbr3kMlKM1A/Tl0PHiIBxOI/AAAAAAAAAFA/78AJpkaPjH8/s1600/aktview.blogspot.com6.png"&gt;&lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 240px;" src="http://3.bp.blogspot.com/-Jbr3kMlKM1A/Tl0PHiIBxOI/AAAAAAAAAFA/78AJpkaPjH8/s320/aktview.blogspot.com6.png" alt="" id="BLOGGER_PHOTO_ID_5646686129886446818" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Once again setup files:&lt;br /&gt;&lt;br /&gt;webOS Quick Installer &lt;a href="http://forums.precentral.net/canuck-coding/274461-webos-quick-install-v4-2-3-a.html"&gt;Click here&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Novacom driver for mac &lt;a href="http://www.filesonic.com/file/1805669734/novacom-mac.tgz"&gt;Click here&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Novacom driver for Windows &lt;a href="http://www.filesonic.com/file/1811371554/novacomInstaller.exe"&gt;Click here&lt;/a&gt; &lt;br /&gt;&lt;br /&gt;This step by step process works for Windows as well.&lt;br /&gt;&lt;br /&gt;Hope you enjoyed the post!!!&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-9052653743184925149?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/9052653743184925149/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=9052653743184925149' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/9052653743184925149'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/9052653743184925149'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2011/08/how-to-install-preware-on-hp-touchpad.html' title='How to install Preware on your HP Touchpad on Mac OS X'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://1.bp.blogspot.com/-DrMAGM9r6dI/Tl0OXPAlG5I/AAAAAAAAAEo/HJzV-XmJxRw/s72-c/aktview.blogspot.com1.png' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-2365184584765921003</id><published>2010-11-28T22:14:00.001-08:00</published><updated>2010-11-28T22:14:27.396-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='UNIX'/><category scheme='http://www.blogger.com/atom/ns#' term='SED'/><title type='text'>Remove text between two patterns</title><content type='html'>This can be done in UNIX by using SED &lt;span class="fullpost"&gt;For example: I want to remove the text between foo and bar    &lt;blockquote&gt;     &lt;p&gt;&amp;#160;&lt;/p&gt;      &lt;p&gt;file.txt contains: &lt;/p&gt;      &lt;p&gt;white&lt;/p&gt;      &lt;p&gt;green&lt;/p&gt;      &lt;p&gt;blue&lt;/p&gt;      &lt;p&gt;foo&lt;/p&gt;      &lt;p&gt;red&lt;/p&gt;      &lt;p&gt;black&lt;/p&gt;      &lt;p&gt;bar&lt;/p&gt;      &lt;p&gt;yellow &lt;/p&gt;   &lt;/blockquote&gt;    &lt;blockquote&gt;     &lt;p&gt;       &lt;br /&gt;sed '/foo/,/bar/{d;}' file.txt &lt;/p&gt;      &lt;p&gt;       &lt;br /&gt;Output: &lt;/p&gt;      &lt;p&gt;white&lt;/p&gt;      &lt;p&gt;green&lt;/p&gt;      &lt;p&gt;blue&lt;/p&gt;      &lt;p&gt;red&lt;/p&gt;      &lt;p&gt;black&lt;/p&gt;      &lt;p&gt;yellow&lt;/p&gt;   &lt;/blockquote&gt; Hope this helps!!! &lt;/span&gt;  &lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-2365184584765921003?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/2365184584765921003/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=2365184584765921003' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/2365184584765921003'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/2365184584765921003'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/11/remove-text-between-two-patterns.html' title='Remove text between two patterns'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-956751481164804746</id><published>2010-11-28T21:52:00.001-08:00</published><updated>2010-11-28T21:54:27.127-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='UNIX'/><category scheme='http://www.blogger.com/atom/ns#' term='PERL'/><title type='text'>Find and Replace from Command Line</title><content type='html'>&lt;p&gt;I had a situation where I had to find and replace in files with out creating new files and renaming them back,&lt;span class="fullpost"&gt; so after some research on Google I came up with this:    &lt;blockquote&gt;     &lt;br /&gt;find . type –f | xargs perl –pi –e 's/foo/bar/g' &lt;/blockquote&gt;&lt;/p&gt; &lt;/span&gt;  &lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-956751481164804746?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/956751481164804746/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=956751481164804746' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/956751481164804746'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/956751481164804746'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/11/find-and-replace-from-command-line.html' title='Find and Replace from Command Line'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-1528922745664967425</id><published>2010-11-28T21:23:00.000-08:00</published><updated>2010-11-28T22:04:36.228-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='UNIX'/><title type='text'>Find text in files using find</title><content type='html'>How to list all files having particular text in UNIX, you can do it by using &lt;strong&gt;find &lt;/strong&gt;and grep &lt;br /&gt;&lt;span class="fullpost"&gt;For example, if we want to list all files in present working directory containing foo, the following command helps    &lt;blockquote&gt;     &lt;br /&gt;find . -type f | xargs grep foo      &lt;br /&gt;&lt;/blockquote&gt;    &lt;br /&gt;Instead of period you can give the directory location.     &lt;blockquote&gt; &lt;br /&gt;     find /usr/home/akt -type f | xargs grep -i foo   &lt;/blockquote&gt;  -i for ignore case&lt;/span&gt;  &lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-1528922745664967425?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/1528922745664967425/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=1528922745664967425' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/1528922745664967425'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/1528922745664967425'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/11/find-text-in-files-using-find.html' title='Find text in files using find'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-3696030326537693137</id><published>2010-03-31T20:30:00.000-07:00</published><updated>2010-03-31T20:35:19.618-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='TERADATA'/><title type='text'>Number of AMP's in Teradata</title><content type='html'>How to get no. of AMP's in Teradata? It's smple, just run the below query:&lt;br /&gt;&lt;span class="fullpost"&gt;       &lt;p&gt;&lt;font face="Courier New"&gt;&lt;br /&gt;&lt;blockquote&gt; &lt;br /&gt;SELECT HASHAMP ( );&lt;br /&gt;&lt;/blockquote&gt;&lt;br /&gt;&lt;/font&gt;&lt;/p&gt; &lt;br /&gt;As AMP's start from 0, you have to add 1&lt;br /&gt;&lt;blockquote&gt;&lt;br /&gt;SELECT HASHAMP ( ) + 1;&lt;br /&gt;&lt;/blockquote&gt;&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-3696030326537693137?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/3696030326537693137/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=3696030326537693137' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/3696030326537693137'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/3696030326537693137'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/03/number-of-amps-in-teradata.html' title='Number of AMP&apos;s in Teradata'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-871646427827656216</id><published>2010-03-24T18:43:00.000-07:00</published><updated>2010-03-24T19:49:12.309-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='MISC'/><title type='text'>How to Connect MacBook Pro to Sony Bravia TV</title><content type='html'>I have recently bought Sony Bravia KDL-40EX500, and my challenge was to connect my MacBook Pro and use it as an external monitor. Is it easy? Yep, all you need is:&lt;br /&gt;&lt;span class="fullpost"&gt;&lt;br /&gt;- Mini DVI to HDMI adapter (I bought this on &lt;a href="http://www.monoprice.com/products/product.asp?c_id=104&amp;cp_id=10419&amp;cs_id=1041912&amp;p_id=4852&amp;seq=1&amp;format=2"&gt;monoprice.com&lt;/a&gt;)&lt;br /&gt;- HDMI cable&lt;br /&gt;- 3.5 mm stero cable male to male&lt;br /&gt;&lt;br /&gt;Now, look for PC/HDMI slot which is behind the LCD TV and audio in which is just above the HDMI slot, see picture (Click to enlarge)&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_51arMaeQndU/S6rIN6kS5XI/AAAAAAAAAD4/Mou1fYQYSp4/s1600/IMG_6113.jpg"&gt;&lt;img style="float:center; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 227px;" src="http://2.bp.blogspot.com/_51arMaeQndU/S6rIN6kS5XI/AAAAAAAAAD4/Mou1fYQYSp4/s320/IMG_6113.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452390440270751090" /&gt;&lt;/a&gt;&lt;br /&gt;Plugin the cables, and get your MacBook Pro and connect the cables, see pictures:&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_51arMaeQndU/S6rJAPnRp-I/AAAAAAAAAEA/VF6sHHxgVu4/s1600/IMG_6114.jpg"&gt;&lt;img style="float:center; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 247px;" src="http://2.bp.blogspot.com/_51arMaeQndU/S6rJAPnRp-I/AAAAAAAAAEA/VF6sHHxgVu4/s320/IMG_6114.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452391304913856482" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_51arMaeQndU/S6rJw1sNRuI/AAAAAAAAAEI/ALsyEHWHEZE/s1600/IMG_6116.jpg"&gt;&lt;img style="float:center; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 320px; height: 240px;" src="http://1.bp.blogspot.com/_51arMaeQndU/S6rJw1sNRuI/AAAAAAAAAEI/ALsyEHWHEZE/s320/IMG_6116.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5452392139768809186" /&gt;&lt;/a&gt;&lt;br /&gt;Now for the TV to work as external monitor, you have to make some changes in the settings, by default when you connect the TV it is considered as second monitor by MacBook Pro. So go to System Preferences &gt; Click on Display and select mirror option, by doing this the display on your MacBook Pro and Sony TV will be same. Now if you close the lid of MacBook Pro, it will go to sleep, to avoid this you have to connect a mouse, key board and plug-in the power adapter. Close the lid and click any key on the keyboard or click the mouse, that's it you are done. Now you can enjoy watching movies from your MacBook Pro on Sony Bravia. Hope you liked the post.&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-871646427827656216?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/871646427827656216/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=871646427827656216' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/871646427827656216'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/871646427827656216'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/03/how-to-connect-macbook-pro-to-sony.html' title='How to Connect MacBook Pro to Sony Bravia TV'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://2.bp.blogspot.com/_51arMaeQndU/S6rIN6kS5XI/AAAAAAAAAD4/Mou1fYQYSp4/s72-c/IMG_6113.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-8599288973024559555</id><published>2010-03-22T21:09:00.000-07:00</published><updated>2010-03-24T18:43:42.763-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='UNIX'/><category scheme='http://www.blogger.com/atom/ns#' term='AWK'/><title type='text'>How to Concatnate using AWK in UNIX</title><content type='html'>I was working on a editing a file using AWK, and I want to concat a string to the output in each line, so I came up with this&lt;br /&gt;&lt;br /&gt;&lt;span class="fullpost"&gt;       &lt;p&gt;&lt;font face="Courier New"&gt;&lt;br /&gt;filename.out contains:&lt;br /&gt;abc def ;&lt;br /&gt;ghi jkl ;&lt;br /&gt;asd fgh ;&lt;br /&gt;&lt;blockquote&gt; &lt;br /&gt;awk '{print $2 "="}' &lt; filename.out&lt;br /&gt;&lt;/blockquote&gt;&lt;br /&gt;Output:&lt;br /&gt;def=&lt;br /&gt;jkl=&lt;br /&gt;fgh=&lt;br /&gt;&lt;/font&gt;&lt;/p&gt; &lt;br /&gt;Don't forget to use the space.&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-8599288973024559555?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/8599288973024559555/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=8599288973024559555' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/8599288973024559555'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/8599288973024559555'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/03/how-to-concat-using-awk-in-unix.html' title='How to Concatnate using AWK in UNIX'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-3483112281860352862</id><published>2010-03-02T21:23:00.000-08:00</published><updated>2010-03-22T21:24:15.096-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='TERADATA'/><title type='text'>Spaces</title><content type='html'>&lt;p&gt;Space Terminology &lt;/p&gt;  &lt;span class="fullpost"&gt;&lt;table style="width: 482pt; border-collapse: collapse" cellspacing="0" cellpadding="0" width="643" border="1" x:str="x:str"&gt;&lt;colgroup&gt;&lt;col style="width: 48pt" width="64" /&gt;&lt;col style="width: 146pt; mso-width-source: userset; mso-width-alt: 7094" width="194" /&gt;&lt;col style="width: 143pt; mso-width-source: userset; mso-width-alt: 6985" width="191" /&gt;&lt;col style="width: 145pt; mso-width-source: userset; mso-width-alt: 7058" width="193" /&gt;&lt;/colgroup&gt;&lt;tbody&gt;     &lt;tr style="height: 12.75pt" height="20"&gt;       &lt;td class="xl24" style="width: 48pt; height: 12.75pt" align="center" width="65" height="17"&gt;&amp;#160;&lt;/td&gt;        &lt;td class="xl26" style="border-left: medium none; width: 146pt" align="center" width="194"&gt;&lt;strong&gt;Perm&lt;/strong&gt;&lt;/td&gt;        &lt;td class="xl26" style="border-left: medium none; width: 143pt" align="center" width="190"&gt;&lt;strong&gt;Spool&lt;/strong&gt;&lt;/td&gt;        &lt;td class="xl26" style="border-left: medium none; width: 145pt" align="center" width="192"&gt;&lt;strong&gt;Temp&lt;/strong&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 54pt; mso-height-source: userset" height="72"&gt;       &lt;td class="xl27" style="border-top: medium none; height: 54pt" width="65" height="72"&gt;&lt;strong&gt;Max&lt;/strong&gt;&lt;/td&gt;        &lt;td class="xl25" style="border-top: medium none; border-left: medium none" width="194"&gt;The maximum number of bytes available for table, index and permanent journal storage in a database or user&lt;/td&gt;        &lt;td class="xl25" style="border-top: medium none; border-left: medium none" width="190"&gt;A value used to limit the number of bytes the system will consume to create spool files for a user&lt;/td&gt;        &lt;td class="xl25" style="border-top: medium none; border-left: medium none" width="192"&gt;A value used to limit the number of bytes the system will use to store data for global temporary tables for a user&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 54pt; mso-height-source: userset" height="72"&gt;       &lt;td class="xl27" style="border-top: medium none; height: 54pt" width="65" height="72"&gt;&lt;strong&gt;Current&lt;/strong&gt;&lt;/td&gt;        &lt;td class="xl25" style="border-top: medium none; border-left: medium none" width="194"&gt;The total number of bytes in use to store the tables, subtables, and permanent journals contained in the database or user&lt;/td&gt;        &lt;td class="xl25" style="border-top: medium none; border-left: medium none" width="190"&gt;The number of bytes currently in use for running transactions&lt;/td&gt;        &lt;td class="xl25" style="border-top: medium none; border-left: medium none" width="192"&gt;The number of bytes in use for global temporary tables&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 54pt; mso-height-source: userset" height="72"&gt;       &lt;td class="xl27" style="border-top: medium none; height: 54pt" width="65" height="72"&gt;&lt;strong&gt;Peak&lt;/strong&gt;&lt;/td&gt;        &lt;td class="xl25" style="border-top: medium none; border-left: medium none" width="194"&gt;The largest number of bytes actually used to store data in this user since the value was last reset&lt;/td&gt;        &lt;td class="xl25" style="border-top: medium none; border-left: medium none" width="190"&gt;The maximum number of bytes used by a transaction run for this user since the value was last reset&lt;/td&gt;        &lt;td class="xl25" style="border-top: medium none; border-left: medium none" width="192"&gt;The maximum number of bytes used by global temporary tables for a user since the value was last reset&lt;/td&gt;     &lt;/tr&gt;   &lt;/tbody&gt;&lt;/table&gt;  &lt;p&gt;Space Limits:&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;Perm and spool space limits are assigned at the database or user level and not at table level &lt;/li&gt;    &lt;li&gt;When creating users or databases, perm space limits are deducted from the available space of the immediate owner &lt;/li&gt;    &lt;li&gt;The spool and temp space limits should not exceed that of the immediate owner at the time of you create the object &lt;/li&gt;    &lt;li&gt;If you do not specify the spool or temp limit, the new object inherits the limit from its immediate owner &lt;/li&gt; &lt;/ul&gt;  &lt;p&gt;Example of space terminology:&lt;/p&gt;  &lt;p&gt;Lets say we have a user HR with MaxPerm space 25 MB, MaxSpool space 50 MB and MaxTemp space 30 MB. Now HR creates two users HR01 and HR02 with 6 MB, 4 MB MaxPerm space respectively and assigning 35 MB MaxSpool space to HR01, as there is spool assigned to HR02, it spool space defaults to its immediate parent MaxSpool space i.e. 50 MB. Now HR is left with 15 MB of MaxPerm space. Later HR drops HR01, HR MaxPerm space increases to 21 MB, since it regains Perm space fro HR01. As there is no MaxTemp space assigned to HR01 and HR02 it is defaulted to their immediate parent to 30 MB.&lt;/p&gt;  &lt;p&gt;&lt;a href="http://lh6.ggpht.com/aktview/SIbMk8jE6MI/AAAAAAAAACw/sRMadH6i_HY/s1600-h/td%5B6%5D.png"&gt;&lt;img title="td" style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="344" alt="td" src="http://lh5.ggpht.com/aktview/SIbMnAfapII/AAAAAAAAAC0/-v27pwTj8a4/td_thumb%5B4%5D.png?imgmax=800" width="482" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;Giving one user to another:&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;When you give one object to another object in the hierarchy, all the space allocated to the object goes with it. If you drop the object the space goes to the immediate owner&lt;/li&gt;    &lt;li&gt;When you give database or user, all descendants (child) of the given object remain descendants (child) of the given object&lt;/li&gt;    &lt;li&gt;When you give an object to a new parent, the ownership of space is transferred&amp;#160; and limits remain the same&lt;/li&gt; &lt;/ul&gt;  &lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-3483112281860352862?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/3483112281860352862/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=3483112281860352862' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/3483112281860352862'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/3483112281860352862'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/03/spaces.html' title='Spaces'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://lh5.ggpht.com/aktview/SIbMnAfapII/AAAAAAAAAC0/-v27pwTj8a4/s72-c/td_thumb%5B4%5D.png?imgmax=800' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-201792243113892516</id><published>2010-03-02T21:22:00.000-08:00</published><updated>2010-03-22T21:23:06.253-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='TERADATA'/><title type='text'>Profiles</title><content type='html'>&lt;p&gt;A set of common parameters that can be applied to a group of users.&lt;/p&gt;  &lt;p&gt;Now you have a question in your mind, what set of common parameters?&lt;/p&gt; &lt;span class="fullpost"&gt;   &lt;ul&gt;     &lt;li&gt;These parameters include: Account id's, default database, spool space allocation, temporary space allocation and password attributes (expiration, minchar, etc.) &lt;/li&gt;      &lt;li&gt;Using profiles simplify user management, a change of a common parameter requires an update of a profile rather than updating each user &lt;/li&gt;      &lt;li&gt;Profiles are managed by        &lt;ul&gt;         &lt;li&gt;&lt;font face="Courier New"&gt;CREATE PROFILE, MODIFY PROFILE, DROP PROFILE, and SELECT PROFILE&lt;/font&gt; &lt;/li&gt;       &lt;/ul&gt;     &lt;/li&gt;   &lt;/ul&gt;    &lt;p&gt;Example: You have a group of 1000 users that are assigned same temporary space, same spool space, same account ID and same default database, if you have to change a single parameter for 1000 users is time consuming. This can be over come by creating a profile with the assigned parameters and assigning that profile to the users. This eases the user management&lt;/p&gt;    &lt;p&gt;Implementing profiles:&lt;/p&gt;    &lt;ul&gt;     &lt;li&gt;CREATE PROFILE: needed to create profiles &lt;/li&gt;      &lt;li&gt;DROP PROFILE: needed to modify and drop profiles &lt;/li&gt;   &lt;/ul&gt;    &lt;p&gt;Initially only DBC has CREATE PROFILE and DROP PROFILE access rights. These can given to DBA's by:&lt;/p&gt;    &lt;blockquote&gt;     &lt;p&gt;&lt;font face="Courier New"&gt;GRANT CREATE PROFILE, DROP PROFILE TO DBA WITH GRANT OPTION;&lt;/font&gt;&lt;/p&gt;   &lt;/blockquote&gt;    &lt;p&gt;In the following section we will see, how to create a PROFILE and assigning a user to a profile:&lt;/p&gt;    &lt;p&gt;Create PROFILE statement:&lt;/p&gt;    &lt;blockquote&gt;     &lt;p&gt;&lt;font face="Courier New"&gt;CREATE PROFILE &lt;em&gt;[profile_name]&lt;/em&gt; AS ACCOUNT = &lt;em&gt;[account_id/null], &lt;/em&gt;DEFAULT DATABASE = &lt;em&gt;[db_name/null], &lt;/em&gt;SPOOL = &lt;em&gt;[bytes/null]&lt;/em&gt;, TEMPORARY = &lt;em&gt;[bytes/null]&lt;/em&gt;, PASSWORD = &lt;em&gt;[password]&lt;/em&gt;;&lt;/font&gt;&lt;/p&gt;      &lt;p&gt;&lt;font face="Courier New"&gt;CREATE PROFILE Emp AS ACCOUNT = '$H2$acct01&amp;amp;H', DEFAULT DATABASE = 'ABC', SPOOL = '20000000', TEMPORARY = '100000000'...;&lt;/font&gt;&lt;/p&gt;   &lt;/blockquote&gt;    &lt;p&gt;Assigning PROFILE to the user: It can be assigned using CREATE USER and MODIFY USER&lt;/p&gt;    &lt;blockquote&gt;     &lt;p&gt;&lt;font face="Courier New"&gt;CREATE USER Emp01 AS..., PROFILE = Emp;&lt;/font&gt;&lt;/p&gt;      &lt;p&gt;&lt;font face="Courier New"&gt;MODIFY USER Emp02 AS PROFILE = Emp;&lt;/font&gt;&lt;/p&gt;   &lt;/blockquote&gt;    &lt;p&gt;To remove profile for a USER:&lt;/p&gt;    &lt;blockquote&gt;     &lt;p&gt;&lt;font face="Courier New"&gt;MODIFY USER Emp02 AS PROFILE=NULL;&lt;/font&gt;&lt;/p&gt;   &lt;/blockquote&gt;    &lt;p&gt;Profile definitions are applied to all users, overriding specifications at system or user level. All members inherit changed profile parameters. The impact on current users is as follows:&lt;/p&gt;    &lt;ul&gt;     &lt;li&gt;SPOOL and TEMP space are imposed immediately &lt;/li&gt;      &lt;li&gt;Password attributes take effect upon next logon &lt;/li&gt;      &lt;li&gt;Database and Account ID's are considered at next logon unless the user submits a SET SESSION ACCOUNT statement &lt;/li&gt;   &lt;/ul&gt;    &lt;p&gt;Order of precedence of parameters:&lt;/p&gt;    &lt;ul&gt;     &lt;li&gt;Specify database or account id's at session level &lt;/li&gt;      &lt;li&gt;Specified parameters in a Profile &lt;/li&gt;      &lt;li&gt;CREATE USER or MODIFY USER statements &lt;/li&gt;   &lt;/ul&gt;    &lt;p&gt;&lt;em&gt;&lt;font size="1"&gt;Source: Teradata Manuals&lt;/font&gt;&lt;/em&gt;&lt;/p&gt; &lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-201792243113892516?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/201792243113892516/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=201792243113892516' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/201792243113892516'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/201792243113892516'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/03/profiles.html' title='Profiles'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-997476455178517352</id><published>2010-03-02T21:20:00.000-08:00</published><updated>2010-03-22T21:23:19.401-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='TERADATA'/><title type='text'>Correlated Subquery - Performance Tuning</title><content type='html'>&lt;p&gt;A correlated subquery (CS) is a subquery whose outer query results are processed a row at a time, against the subquery result. The subquery result is computed for each row processed.&lt;/p&gt;  &lt;ul&gt;   &lt;li&gt;a CS eliminates the need for intermediate or temporary tables &lt;/li&gt;    &lt;li&gt;a CS is fully integrated with global join planning to minimize costs &lt;/li&gt;    &lt;li&gt;CS is significantly faster than the query using temporary tables &lt;/li&gt; &lt;/ul&gt;&lt;span class="fullpost"&gt;  &lt;p&gt;Example:&lt;/p&gt;  &lt;p&gt;1. Employee with highest salary in each department&lt;/p&gt;  &lt;blockquote&gt;   &lt;p&gt;&lt;font face="Courier New"&gt;SELECT L_Na,Sal, D_No        &lt;br /&gt;FROM test.employee ee         &lt;br /&gt;WHERE Sal = (SELECT MAX (Sal)         &lt;br /&gt;FROM test.employee em         &lt;br /&gt;WHERE ee.D_No=em.D_No);&lt;/font&gt;&lt;/p&gt; &lt;/blockquote&gt;  &lt;p&gt;Answer Set:&lt;/p&gt;  &lt;table style="width: 181pt; border-collapse: collapse" cellspacing="0" cellpadding="0" width="241" border="1"&gt;&lt;colgroup&gt;&lt;col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779" width="76" /&gt;&lt;col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730" width="102" /&gt;&lt;col style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267" width="62" /&gt;&lt;/colgroup&gt;&lt;tbody&gt;     &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="width: 57pt; height: 15pt" width="76" height="20"&gt;Last_Name&lt;/td&gt;        &lt;td class="xl65" style="border-left: medium none; width: 77pt" width="101"&gt;Salary_Amount&lt;/td&gt;        &lt;td class="xl65" style="border-left: medium none; width: 47pt" width="62"&gt;Dept_No&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;stifler&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;60000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;50&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;pitt&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;70000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;10&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;young&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;60000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;50&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;jones&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;60000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;30&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;paul&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;70000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;70&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;penn&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;60000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;60&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;white&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;75000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;90&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;nelson&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;70000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;80&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;pitt&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;45000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;100&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;lucas&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;75000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;20&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="76" height="20"&gt;phips&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;65000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;40&lt;/td&gt;     &lt;/tr&gt;   &lt;/tbody&gt;&lt;/table&gt;  &lt;p&gt;2. Employees whose salary is greater than the department average salary&lt;/p&gt;  &lt;blockquote&gt;   &lt;p&gt;&lt;font face="Courier New"&gt;SELECT L_Na, Sal, D_No       &lt;br /&gt;FROM test.employee ee        &lt;br /&gt;WHERE Sal &amp;gt; (SELECT AVG (Sal)        &lt;br /&gt;FROM test.employee em        &lt;br /&gt;WHERE ee.D_No= em.D_No);&lt;/font&gt;&lt;/p&gt; &lt;/blockquote&gt;  &lt;p&gt;Answer Set:&lt;/p&gt;  &lt;table style="width: 180pt; border-collapse: collapse" cellspacing="0" cellpadding="0" width="240" border="1"&gt;&lt;colgroup&gt;&lt;col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742" width="75" /&gt;&lt;col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730" width="102" /&gt;&lt;col style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267" width="62" /&gt;&lt;/colgroup&gt;&lt;tbody&gt;     &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="width: 56pt; height: 15pt" width="75" height="20"&gt;Last_Name&lt;/td&gt;        &lt;td class="xl65" style="border-left: medium none; width: 77pt" width="101"&gt;Salary_Amount&lt;/td&gt;        &lt;td class="xl65" style="border-left: medium none; width: 47pt" width="62"&gt;Dept_No&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="75" height="20"&gt;paul&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;70000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;70&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="75" height="20"&gt;phips&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;65000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;40&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="75" height="20"&gt;shook&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;65000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;10&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="75" height="20"&gt;pitt&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;70000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;10&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="75" height="20"&gt;jones&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;60000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;30&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="75" height="20"&gt;lucas&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;75000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;20&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" width="75" height="20"&gt;wall&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;65000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="62"&gt;10&lt;/td&gt;     &lt;/tr&gt;   &lt;/tbody&gt;&lt;/table&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-997476455178517352?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/997476455178517352/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=997476455178517352' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/997476455178517352'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/997476455178517352'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/03/correlated-subquery-performance-tuning.html' title='Correlated Subquery - Performance Tuning'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-5906881671101080897</id><published>2010-03-02T21:19:00.000-08:00</published><updated>2010-03-22T21:20:20.875-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='TERADATA'/><title type='text'>Concatenation and Correlated Subqueries - Performance Tuning</title><content type='html'>&lt;p&gt;Concatenation allows to retrieve data correlated to the MIN/MAX function in a single pass&lt;/p&gt; &lt;span class="fullpost"&gt; &lt;p&gt;Example:&lt;/p&gt;  &lt;p&gt;1. Employees with highest salary in each department&lt;/p&gt;  &lt;p&gt;This can be written as using correlated subquery&lt;/p&gt;  &lt;blockquote&gt;   &lt;p&gt;&lt;font face="Courier New"&gt;SELECT D_No, Sal, L_Na, F_Na        &lt;br /&gt;FROM test.employee ee         &lt;br /&gt;WHERE Sal IN         &lt;br /&gt;(SELECT MAX (Sal)         &lt;br /&gt;FROM test.employee em         &lt;br /&gt;WHERE ee.D_No=em.D_No         &lt;br /&gt;GROUP BY D_No)         &lt;br /&gt;ORDER BY D_No;&lt;/font&gt;&lt;/p&gt; &lt;/blockquote&gt;  &lt;p&gt;Answer Set:&lt;/p&gt;  &lt;table style="width: 240pt; border-collapse: collapse" cellspacing="0" cellpadding="0" width="320" border="1"&gt;&lt;colgroup&gt;&lt;col style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267" width="62" /&gt;&lt;col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730" width="102" /&gt;&lt;col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779" width="76" /&gt;&lt;col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852" width="78" /&gt;&lt;/colgroup&gt;&lt;tbody&gt;     &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="width: 47pt; height: 15pt" width="61" height="20"&gt;Dept_No&lt;/td&gt;        &lt;td class="xl65" style="border-left: medium none; width: 77pt" width="102"&gt;Salary_Amount&lt;/td&gt;        &lt;td class="xl65" style="border-left: medium none; width: 57pt" width="77"&gt;Last_Name&lt;/td&gt;        &lt;td class="xl65" style="border-left: medium none; width: 59pt" width="78"&gt;First_Name&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;10&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="102"&gt;70000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="77"&gt;pitt&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;arun&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;20&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;75000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;lucas&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;frank&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;30&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;60000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;jones&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;indiana&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;40&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;65000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;phips&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;carla&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;50&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;60000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;stifler&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;tom&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;50&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;60000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;young&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;nikie&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;60&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;60000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;penn&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;arun&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;70&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;70000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;paul&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;ak&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;80&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;70000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;nelson&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;julie&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;90&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;75000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;white&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;sam&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="61" height="20"&gt;100&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" align="right" width="101"&gt;45000&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;pitt&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="78"&gt;mark&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;   &lt;/tbody&gt;&lt;/table&gt;  &lt;p&gt;&lt;font face="tr"&gt;It can also be written as&lt;/font&gt;&lt;/p&gt;  &lt;blockquote&gt;   &lt;p&gt;&lt;font face="Courier New"&gt;SELECT D_No,        &lt;br /&gt;MAX(Sal || ' ' || L_Na || ',' ||F_Na)         &lt;br /&gt;FROM test.employee         &lt;br /&gt;GROUP BY D_No         &lt;br /&gt;ORDER BY D_No ;&lt;/font&gt;&lt;/p&gt; &lt;/blockquote&gt;  &lt;p&gt;Answer Set:&lt;/p&gt;  &lt;table style="width: 363pt; border-collapse: collapse" cellspacing="0" cellpadding="0" width="484" border="1"&gt;&lt;colgroup&gt;&lt;col style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267" width="62" /&gt;&lt;col style="width: 316pt; mso-width-source: userset; mso-width-alt: 15396" width="421" /&gt;&lt;/colgroup&gt;&lt;tbody&gt;     &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="width: 47pt; height: 15pt" width="63" height="20"&gt;Dept_No&lt;/td&gt;        &lt;td class="xl65" style="border-left: medium none; width: 316pt" width="419"&gt;Maximum(((((Salary_Amount||' ')||Last_Name)||',')||First_Nam&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="63" height="20"&gt;10&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="419"&gt;&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;70000 pitt&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;,arun&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="63" height="20"&gt;20&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="419"&gt;&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;75000 lucas&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;,frank&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="63" height="20"&gt;30&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="419"&gt;&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;60000 jones&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;,indiana&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="63" height="20"&gt;40&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="419"&gt;&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;65000 phips&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;,carla&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="63" height="20"&gt;50&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="419"&gt;&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;60000 young&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;,nikie&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="63" height="20"&gt;60&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="419"&gt;&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;60000 penn&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;,arun&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="63" height="20"&gt;70&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="419"&gt;&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;70000 paul&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;,ak&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="63" height="20"&gt;80&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="419"&gt;&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;70000 nelson&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;,julie&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="63" height="20"&gt;90&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="419"&gt;&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;75000 white&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;,sam&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;      &lt;tr style="height: 15pt" height="20"&gt;       &lt;td class="xl65" style="border-top: medium none; height: 15pt" align="right" width="63" height="20"&gt;100&lt;/td&gt;        &lt;td class="xl65" style="border-top: medium none; border-left: medium none" width="419"&gt;&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;45000 pitt&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;,mark&lt;span style="mso-spacerun: yes"&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/span&gt;&lt;/td&gt;     &lt;/tr&gt;   &lt;/tbody&gt;&lt;/table&gt;  &lt;p&gt;Did you observe the two answer sets? Can you tell the difference and how to overcome it? Please leave your answers in comments.&lt;/p&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-5906881671101080897?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/5906881671101080897/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=5906881671101080897' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/5906881671101080897'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/5906881671101080897'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/03/concatenation-and-correlated-subqueries.html' title='Concatenation and Correlated Subqueries - Performance Tuning'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-8228506401031329856</id><published>2010-02-02T21:19:00.000-08:00</published><updated>2010-03-22T21:19:51.365-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='TERADATA'/><title type='text'>Create User</title><content type='html'>&lt;p&gt;Create &lt;a href="http://tdwire.blogspot.com/2008/09/databases-and-users.html"&gt;user&lt;/a&gt; is used to add a new user to the system. As discussed earlier user is similar to database except that a user can logon with a password and run queries. Below is the create user SQL&lt;/p&gt; &lt;span class="fullpost"&gt;   &lt;blockquote&gt;     &lt;p&gt;&lt;font face="Courier New"&gt;CREATE USER &lt;em&gt;[user_name]&lt;/em&gt; FROM &lt;em&gt;[dbname]&lt;/em&gt; AS           &lt;br /&gt;PERM = &lt;em&gt;[bytes]&lt;/em&gt;           &lt;br /&gt;PASSWORD = &lt;em&gt;[password/null]&lt;/em&gt;           &lt;br /&gt;STARTUP = &lt;em&gt;[string]&lt;/em&gt;           &lt;br /&gt;TEMPORARY = &lt;em&gt;[bytes]&lt;/em&gt;           &lt;br /&gt;DEFAULT DATABASE = &lt;em&gt;[dbname]&lt;/em&gt;           &lt;br /&gt;COLLATION = &lt;em&gt;[collation_sequence]&lt;/em&gt;           &lt;br /&gt;ACCOUNT = &lt;em&gt;[account_id]&lt;/em&gt;           &lt;br /&gt;[NO] FALLBACK           &lt;br /&gt;[NO/DUAL] BEFORE JOURNAL           &lt;br /&gt;[NO/DUAL/LOCAL/NOTLOCAL] AFTER JOURNAL           &lt;br /&gt;DEFAULT JOURNAL TABLE = &lt;em&gt;[name].[table_name]&lt;/em&gt;;&lt;/font&gt;&lt;/p&gt;   &lt;/blockquote&gt;    &lt;p&gt;SQL with parameter:&lt;/p&gt;    &lt;blockquote&gt;     &lt;p&gt;&lt;font face="Courier New"&gt;CREATE USER testuser FROM DBC          &lt;br /&gt;AS           &lt;br /&gt;&amp;#160;&amp;#160; PASSWORD=user1           &lt;br /&gt;&amp;#160;&amp;#160; PERM=2000000           &lt;br /&gt;&amp;#160;&amp;#160; SPOOL=5000000           &lt;br /&gt;&amp;#160;&amp;#160; TEMPORARY=0           &lt;br /&gt;&amp;#160;&amp;#160; STARTUP='SET SESSION ANSI'&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;br /&gt;&amp;#160;&amp;#160; ACCOUNT='$LUSER'           &lt;br /&gt;&amp;#160;&amp;#160; DEFAULT DATABASE=test           &lt;br /&gt;&amp;#160;&amp;#160; COLLATION= HOST           &lt;br /&gt;&amp;#160;&amp;#160; NO FALLBACK           &lt;br /&gt;&amp;#160;&amp;#160; NO BEFORE JOURNAL           &lt;br /&gt;&amp;#160;&amp;#160; NO AFTER JOURNAL;&lt;/font&gt;&lt;/p&gt;   &lt;/blockquote&gt;    &lt;p&gt;&lt;em&gt;&lt;font size="1"&gt;Source: Teradata Manuals&lt;/font&gt;&lt;/em&gt;&lt;/p&gt; &lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-8228506401031329856?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/8228506401031329856/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=8228506401031329856' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/8228506401031329856'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/8228506401031329856'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2010/03/create-user.html' title='Create User'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-5719997248382776603</id><published>2008-11-30T08:00:00.000-08:00</published><updated>2010-03-22T21:09:06.965-07:00</updated><title type='text'>Global Imbalance - An Imminent Dollar Crisis</title><content type='html'>An excellent presentation on global imbalance and American economy by &lt;a href="http://www.google.com/search?hl=en&amp;rlz=1C1GGLS_enUS303US303&amp;q=mr+venkatesh&amp;btnG=Search"&gt;M.R. Venkatesh&lt;/a&gt;, Economist. Watch all parts. Please leave your comments.&lt;br /&gt;Part 1:&lt;br /&gt;&lt;object width="425" height="344"&gt;&lt;param name="movie" value="http://www.youtube.com/v/xVotQAYOs1o&amp;hl=en&amp;fs=1"&gt;&lt;/param&gt;&lt;param name="allowFullScreen" value="true"&gt;&lt;/param&gt;&lt;param name="allowscriptaccess" value="always"&gt;&lt;/param&gt;&lt;embed src="http://www.youtube.com/v/xVotQAYOs1o&amp;hl=en&amp;fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;br /&gt;Part 2:&lt;br /&gt;&lt;object width="425" height="344"&gt;&lt;param name="movie" value="http://www.youtube.com/v/sGToGEUT5Hc&amp;hl=en&amp;fs=1"&gt;&lt;/param&gt;&lt;param name="allowFullScreen" value="true"&gt;&lt;/param&gt;&lt;param name="allowscriptaccess" value="always"&gt;&lt;/param&gt;&lt;embed src="http://www.youtube.com/v/sGToGEUT5Hc&amp;hl=en&amp;fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;br /&gt;Part 3:&lt;br /&gt;&lt;object width="425" height="344"&gt;&lt;param name="movie" value="http://www.youtube.com/v/B7_EozGE1bs&amp;hl=en&amp;fs=1"&gt;&lt;/param&gt;&lt;param name="allowFullScreen" value="true"&gt;&lt;/param&gt;&lt;param name="allowscriptaccess" value="always"&gt;&lt;/param&gt;&lt;embed src="http://www.youtube.com/v/B7_EozGE1bs&amp;hl=en&amp;fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;br /&gt;Part 4:&lt;br /&gt;&lt;object width="425" height="344"&gt;&lt;param name="movie" value="http://www.youtube.com/v/7S9F1MF_Cgk&amp;hl=en&amp;fs=1"&gt;&lt;/param&gt;&lt;param name="allowFullScreen" value="true"&gt;&lt;/param&gt;&lt;param name="allowscriptaccess" value="always"&gt;&lt;/param&gt;&lt;embed src="http://www.youtube.com/v/7S9F1MF_Cgk&amp;hl=en&amp;fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;br /&gt;Part 5:&lt;br /&gt;&lt;object width="425" height="344"&gt;&lt;param name="movie" value="http://www.youtube.com/v/TK3Vu5ALapM&amp;hl=en&amp;fs=1"&gt;&lt;/param&gt;&lt;param name="allowFullScreen" value="true"&gt;&lt;/param&gt;&lt;param name="allowscriptaccess" value="always"&gt;&lt;/param&gt;&lt;embed src="http://www.youtube.com/v/TK3Vu5ALapM&amp;hl=en&amp;fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;br /&gt;Part 6:&lt;br /&gt;&lt;object width="425" height="344"&gt;&lt;param name="movie" value="http://www.youtube.com/v/cc-x8t2GzGM&amp;hl=en&amp;fs=1"&gt;&lt;/param&gt;&lt;param name="allowFullScreen" value="true"&gt;&lt;/param&gt;&lt;param name="allowscriptaccess" value="always"&gt;&lt;/param&gt;&lt;embed src="http://www.youtube.com/v/cc-x8t2GzGM&amp;hl=en&amp;fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-5719997248382776603?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/5719997248382776603/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=5719997248382776603' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/5719997248382776603'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/5719997248382776603'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/11/global-imbalance-imminent-dollar-crisis.html' title='Global Imbalance - An Imminent Dollar Crisis'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-7997287621204896840</id><published>2008-06-12T11:34:00.000-07:00</published><updated>2010-03-22T21:03:15.789-07:00</updated><title type='text'>KCP Siddhartha Adarsh Residential Public School - Google Maps</title><content type='html'>&lt;iframe width="100%" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.com/maps?f=q&amp;amp;hl=en&amp;amp;geocode=&amp;amp;q=kcp+siddhartha+adarsh+residential+public+school,+vijayawada&amp;amp;sll=16.515449,80.631548&amp;amp;sspn=0.005575,0.011019&amp;amp;ie=UTF8&amp;amp;cd=1&amp;amp;t=h&amp;amp;ll=16.50488,80.685031&amp;amp;spn=0.002628,0.005536&amp;amp;z=18&amp;amp;output=embed&amp;amp;s=AARTsJrFltvz73d3J5EHpWj3B36o5nNIng"&gt;&lt;/iframe&gt;&lt;br /&gt;&lt;small&gt;&lt;a href="http://maps.google.com/maps?f=q&amp;amp;hl=en&amp;amp;geocode=&amp;amp;q=kcp+siddhartha+adarsh+residential+public+school,+vijayawada&amp;amp;sll=16.515449,80.631548&amp;amp;sspn=0.005575,0.011019&amp;amp;ie=UTF8&amp;amp;cd=1&amp;amp;t=h&amp;amp;ll=16.50488,80.685031&amp;amp;spn=0.002628,0.005536&amp;amp;z=18&amp;amp;source=embed" style="color:#0000FF;text-align:left"&gt;View Larger Map&lt;/a&gt;&lt;/small&gt;&lt;br /&gt;KCP Siddhartha Adarsh Residential Public School On Google Maps located at Kanuru, Vijayawada&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-7997287621204896840?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/7997287621204896840/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=7997287621204896840' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/7997287621204896840'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/7997287621204896840'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/06/kcp-siddhartha-adarsh-residential.html' title='KCP Siddhartha Adarsh Residential Public School - Google Maps'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-4459300439056073401</id><published>2008-03-09T20:10:00.000-07:00</published><updated>2010-03-22T21:03:38.091-07:00</updated><title type='text'>Smile :)</title><content type='html'>&lt;div style="text-align: center;"&gt;&lt;img src="http://farm3.static.flickr.com/2301/2321510521_b9aa39ed83_m.jpg" alt="" /&gt;&lt;span style="font-size:85%;"&gt;&lt;a href="http://flickr.com/photos/davidwatts1978/2321510521/"&gt;[S]&lt;/a&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt; &lt;div style="text-align: center;"&gt;&lt;br /&gt;&lt;br /&gt;&lt;img src="http://farm3.static.flickr.com/2164/2321505057_d3c931b704_m.jpg" alt="" /&gt;&lt;a href="http://flickr.com/photos/delay_tactics/2321505057/"&gt;&lt;span style="font-size:85%;"&gt;[S]&lt;/span&gt; &lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;br /&gt;&lt;div style="text-align: center;"&gt;&lt;img src="http://farm3.static.flickr.com/2120/2320836739_64aa9d86d2_m.jpg" alt="" /&gt;&lt;a href="http://flickr.com/photos/7518432@N06/2320836739/"&gt;&lt;span style="font-size:85%;"&gt;[S]&lt;/span&gt; &lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;br /&gt;&lt;div style="text-align: center;"&gt;&lt;img src="http://farm3.static.flickr.com/2416/2320418399_c38b61e953_m.jpg" alt="" /&gt;&lt;a href="http://flickr.com/photos/seian/2320418399/"&gt;&lt;span style="font-size:85%;"&gt;[S]&lt;/span&gt; &lt;/a&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-4459300439056073401?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/4459300439056073401/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=4459300439056073401' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/4459300439056073401'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/4459300439056073401'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/03/smile.html' title='Smile :)'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://farm3.static.flickr.com/2301/2321510521_b9aa39ed83_t.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-8059437198058592256</id><published>2008-03-07T06:53:00.000-08:00</published><updated>2010-03-22T21:03:48.342-07:00</updated><title type='text'>7 Tips | Easy Ways to Improve Your Vision</title><content type='html'>&lt;div style="text-align: center;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://farm3.static.flickr.com/2241/2181970318_1ab407d2a6_m.jpg"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 200px;" src="http://farm3.static.flickr.com/2241/2181970318_1ab407d2a6_m.jpg" alt="" border="0" /&gt;&lt;/a&gt;&lt;span style="font-size:78%;"&gt;Image courtesy: &lt;a href="http://www.flickr.com/photos/godsemerald/"&gt;Gods Emerald&lt;/a&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;They are two of your most precious possessions, but chances are, you take your eyes for granted. Most of us do. But think for a second what life would be like without being able to gaze on your grandchild or your flower garden or even navigate the kitchen without incident &lt;p&gt;   &lt;br /&gt; &lt;br /&gt;   Prevent Blindness America, a nonprofit organization dedicated     to vision issues, estimates that 50,000 people lose their sight     needlessly every year and that 80 million Americans are at risk     of eye diseases that can lead to low vision and even     blindness.&lt;br /&gt; &lt;br /&gt; &lt;br /&gt;   The good news: The most common diseases — age-related macular     degeneration (&lt;span class="caps"&gt;ARMD&lt;/span&gt;), cataracts,     glaucoma, and dry eye disease — are all preventable to some     extent. Read on to see (pun intended) how you can get Stealth     Healthy protection for your peepers. Before we go any further,     we have to tell you that the first step, if you smoke, is to     stop. Smoking increases your risk of cataracts, glaucoma, dry     eyes, and age-related macular degeneration.&lt;br /&gt; &lt;br /&gt; &lt;br /&gt;&lt;/p&gt; &lt;p&gt;     &lt;b&gt;1. Mix a cup of blueberries with a cup of yogurt for     breakfast this morning.&lt;/b&gt; Blueberries are one of the richest     fruit forms of antioxidants, and a study published in &lt;i&gt;The     Archives of Ophthalmology&lt;/i&gt; found that women and men who ate     the greatest amount of fruit were the least likely to develop     age-related macular degeneration (&lt;span class="caps"&gt;ARMD&lt;/span&gt;), the leading cause of blindness in older     people.&lt;br /&gt; &lt;br /&gt; &lt;br /&gt;   &lt;b&gt;2. Spread bilberry jam on your morning toast.&lt;/b&gt; Or take a     bilberry supplement every morning. The berries contain     compounds called anthocyanosides, which may protect the retina     against macular degeneration. &lt;/p&gt; &lt;p&gt;   &lt;br /&gt; &lt;br /&gt;   &lt;b&gt;3. Have spinach twice a week.&lt;/b&gt; Could be a spinach quiche,     steamed spinach, or maybe Tuscan&lt;br /&gt;   spinach — sautéed in some olive oil with garlic and raisins.     Regardless, be sure to get your spinach. Studies find that     lutein, a nutrient that is particularly abundant in spinach,     may prevent age-related macular degeneration and cataracts.     Ideally, get your lutein in combination with some form of fat     (olive oil works great) for the best absorption.&lt;br /&gt; &lt;br /&gt; &lt;br /&gt;   &lt;b&gt;4. Cook with red onions, not yellow.&lt;/b&gt; Red onions contain     far more quercetin, an antioxidant that is thought to protect     against cataracts.&lt;br /&gt; &lt;br /&gt; &lt;br /&gt;   &lt;b&gt;5. Aim your car vents at your feet — not your eyes.&lt;/b&gt; Dry,     air-conditioned air will suck the moisture out of eyes like a     sponge. Aim the vents in your car away from your eyes, or wear     sunglasses as a shield. Dry eyes can be more than an     inconvenience; serious dryness can lead to&lt;br /&gt;   &lt;span id="advertisement"&gt;&lt;/span&gt;&lt;br /&gt;   corneal abrasions and even blindness if left untreated.&lt;br /&gt; &lt;br /&gt; &lt;br /&gt;   &lt;b&gt;6. Move your computer screen to just below eye level.&lt;/b&gt;     Your eyes will close slightly when you’re staring at the     computer, minimizing fluid evaporation and the risk of dry eye     syndrome, says John Sheppard, M.D., who directs the     ophthalmology residency program at Eastern Virginia Medical     School in Norfolk, Virginia. &lt;/p&gt;    &lt;br /&gt; &lt;br /&gt;   &lt;b&gt;7. Take a multivitamin every day.&lt;/b&gt; Make it a habit, like     brushing your teeth. A major study suggested that if every     American at risk for age-related macular degeneration took     daily supplements of antioxidant vitamins and zinc, more than     300,000 people could avoid ARMD-associated vision loss over the     next five years. Other studies find that women who took vitamin     C supplements for at least 10 years were 77 percent less likely     to show initial signs of cataracts than those who took no     supplemental C. So take a multi with at least 150 mg vitamin C,     or take a separate C supplement&lt;br /&gt;&lt;br /&gt;&lt;span style="font-size:85%;"&gt;[Via Email Forward]&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-8059437198058592256?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/8059437198058592256/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=8059437198058592256' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/8059437198058592256'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/8059437198058592256'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/03/7-tips-easy-ways-to-improve-your-vision.html' title='7 Tips | Easy Ways to Improve Your Vision'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://farm3.static.flickr.com/2241/2181970318_1ab407d2a6_t.jpg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-8182613801154076933</id><published>2008-03-05T10:13:00.000-08:00</published><updated>2010-03-22T21:03:58.792-07:00</updated><title type='text'>20 Ways to Eliminate Stress</title><content type='html'>&lt;div&gt;&lt;br /&gt;&lt;div style="text-align: center;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://aktview.blogspot.com/"&gt;&lt;img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px;" src="http://farm1.static.flickr.com/19/98831359_49ede3af3b.jpg?v=0" alt="" border="0" /&gt;&lt;/a&gt;&lt;span style="font-size:78%;"&gt;Image Courtesy:&lt;a href="http://www.flickr.com/photos/belljar/"&gt;Esther_G&lt;/a&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;br /&gt;What is Stress? Stress is a result of challenges in life, and a life without challenges is too boring.This article gives you simple ways to eliminate the stress and lead a stress free life. &lt;a href="http://zenhabits.net/2007/06/20-ways-to-eliminate-stress-from-your-life/"&gt;Read More&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-size:85%;"&gt;[Via &lt;a href="http://zenhabits.net/"&gt;ZenHabits&lt;/a&gt;]&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-8182613801154076933?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/8182613801154076933/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=8182613801154076933' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/8182613801154076933'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/8182613801154076933'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/03/20-ways-to-eliminate-stress.html' title='20 Ways to Eliminate Stress'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-4924751626953861793</id><published>2008-03-05T09:56:00.000-08:00</published><updated>2010-03-22T21:04:10.598-07:00</updated><title type='text'>31 Ways to Find Inspiration for Your Writing</title><content type='html'>&lt;div style="text-align: center;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://aktview.blogspot.com/"&gt;&lt;img style="cursor: pointer; width: 400px;" src="http://farm1.static.flickr.com/39/96776343_4efe3075ff.jpg?v=0" alt="" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-size:78%;"&gt;Image Courtesy:&lt;a href="http://www.flickr.com/photos/belljar/"&gt;Esther_G&lt;/a&gt;&lt;/span&gt;&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;Lacking inspiration to write. This is what you looking for, this post inspires you to write good articles.&lt;a href="http://writetodone.com/2008/03/03/31-ways-to-find-inspiration-for-your-writing/"&gt;Read More&gt;&lt;/a&gt;&lt;br /&gt;&lt;span style="font-size:85%;"&gt;[Via &lt;a href="http://writetodone.com/"&gt;WritetoDone&lt;/a&gt;]&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-4924751626953861793?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/4924751626953861793/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=4924751626953861793' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/4924751626953861793'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/4924751626953861793'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/03/31-ways-to-find-inspiration-for-your.html' title='31 Ways to Find Inspiration for Your Writing'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-2386212682653313360</id><published>2008-02-28T20:04:00.000-08:00</published><updated>2010-03-22T21:04:19.504-07:00</updated><title type='text'>Star Wars according to a 3 year old</title><content type='html'>&lt;fieldset&gt;&lt;br /&gt;&lt;legend&gt;Star Wars according to a 3 year old&lt;/legend&gt;&lt;br /&gt;&lt;object width="100%" height="400"&gt;&lt;param name="movie" value="http://www.youtube.com/v/EBM854BTGL0"&gt;&lt;/param&gt;&lt;param name="wmode" value="transparent"&gt;&lt;/param&gt;&lt;embed src="http://www.youtube.com/v/EBM854BTGL0" type="application/x-shockwave-flash" wmode="transparent" width="100%" height="400"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;br /&gt;&lt;/fieldset&gt;&lt;br /&gt;&lt;br /&gt;So Cute :)&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-2386212682653313360?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/2386212682653313360/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=2386212682653313360' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/2386212682653313360'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/2386212682653313360'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/02/star-wars-according-to-3-year-old.html' title='Star Wars according to a 3 year old'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-7406507065321879856</id><published>2008-02-18T00:25:00.000-08:00</published><updated>2010-03-22T21:04:30.006-07:00</updated><title type='text'>Fixed-Schedule Productivity</title><content type='html'>I came across this nice article on how to accomplish large amount of work in a small number of work hours. This is worth reading. Its all about how you schedule your work and making it work for you. &lt;a href="http://calnewport.com/blog/?p=275"&gt;Read More&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-7406507065321879856?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/7406507065321879856/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=7406507065321879856' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/7406507065321879856'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/7406507065321879856'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/02/fixed-schedule-productivity.html' title='Fixed-Schedule Productivity'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-9142662556786812014</id><published>2008-02-18T00:08:00.000-08:00</published><updated>2010-03-22T21:04:39.582-07:00</updated><title type='text'>How To Choose The Right Goals To Focus On</title><content type='html'>Sometimes setting goals alone is not the only problem that you must face. Sometimes, choosing the right goals to begin with is harder.&lt;br /&gt;Basically, you can choose to work any goal that you feel is necessary for your health, stability and happiness.&lt;br /&gt;Goal setting is nothing more than a formal process for personal planning. By setting goals on a routine basis you decide what you want to achieve, and then move in a step-by-step manner towards the achievement of these goals.&lt;br /&gt;The process of setting goals and targets allows you to choose where you want to go in life. By knowing exactly what you want to achieve, you know what you have to concentrate on to do it. You also know what nothing more than a distraction is.&lt;br /&gt;Goal setting is a standard technique used by professional athletes, successful business people and high achievers in all fields. It gives you long term vision and provides you with short term motivation.&lt;br /&gt;It helps to focus your attention and knowledge which helps you to organize your resources. By setting sharp and clearly defined goals, you can measure and take pride in the achievement of those goals. You can see forward progress in what might previously have seemed a long pointless effort.&lt;br /&gt;By setting goals, you will also raise your self confidence, as you recognize your and ability to meet the goals that you have set. The process of achieving goals and seeing this achievement gives you confidence that you will be able to achieve higher and more difficult goals later on.&lt;br /&gt;Goals are set on a number of different levels. In the first place, you decide what you want to do with your life and what large scale goals you want to achieve.&lt;br /&gt;Second, you break these down into the smaller aims that you must hit so that you reach your overall lifetime goals.&lt;br /&gt;Finally, once you have your plan, you start working towards achieving it.&lt;br /&gt;&lt;br /&gt;By Christos Varsami [Via Email Forward]&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-9142662556786812014?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/9142662556786812014/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=9142662556786812014' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/9142662556786812014'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/9142662556786812014'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/02/how-to-choose-right-goals-to-focus-on.html' title='How To Choose The Right Goals To Focus On'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-1278644259064063974</id><published>2008-02-13T13:25:00.001-08:00</published><updated>2010-03-22T21:04:49.164-07:00</updated><title type='text'>Eye Care - For Better Eyes</title><content type='html'>1. Never work in dim light&lt;br /&gt;&lt;br /&gt;2. Wear sunglasses out in the sun&lt;br /&gt;&lt;br /&gt;3. Do not read continuously in moving vehicles, take break&lt;br /&gt;&lt;br /&gt;4. Eat plenty of fruits and vegetables such as carrots, spinach, papaya and mangoes because these are enriched with beta carotene and are excellent for healthy eyes and proper vision&lt;br /&gt;&lt;br /&gt;5. Apply cucumber water or thin slices of cucumber to the skin around the eyes, especially if this skin is looking dry. It improves your vision and also reduces puffs and bags under the eyes. This the best and easiest eye care tips&lt;br /&gt;&lt;br /&gt;6. Apply all-natural eye drops&lt;br /&gt;&lt;br /&gt;7. Splash eyes with cold water. Apply cotton wool pads, soaked in warm milk, light tea solution or rose water on the eyes. Press gently and leave for 10 minutes&lt;br /&gt;&lt;br /&gt;8. Do regular eye exercise and make it a practice&lt;br /&gt;&lt;br /&gt;Simple Exercises:&lt;br /&gt;&lt;p align="left"&gt;&lt;a href="http://www.photocase.de/en/upload/07/yqo4tigy/photocase297635943.jpg"&gt;&lt;img style="WIDTH: 100px; CURSOR: hand" alt="" src="http://www.photocase.de/en/upload/07/yqo4tigy/photocase297635943.jpg" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;1. Lift the eyes to the ceiling and then to the floor. Repeat. Look straight ahead, then to the left and then to the right. Repeat. Make a circle, first clockwise and then anticlockwise, with the eyes. Repeat&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;2. Rub your hands together until they feel warm, close your eyes and cover them lightly with cupped palms. Without applying too much pressure on the closed eyelids, place your palms on your eyes so that your nose remains uncovered, and no light rays are able to enter the eyes. Take deep breaths slowly and evenly, and relax yourself, and after your eyes see nothing but blackness, remove your palms from your eyes. Repeat &lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-1278644259064063974?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/1278644259064063974/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=1278644259064063974' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/1278644259064063974'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/1278644259064063974'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/02/eye-care-for-better-eyes.html' title='Eye Care - For Better Eyes'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-4204898040606119378</id><published>2008-02-12T15:03:00.000-08:00</published><updated>2010-03-22T21:05:20.011-07:00</updated><title type='text'>Creating and Managing a Lean Supply Chain</title><content type='html'>&lt;div&gt;&lt;span&gt;Lean supply chain management is not just  for manufacturers who practice lean manufacturing. Nor is it just for large  retailers. It is a practice that can benefit small and mid-size home furnishings  retailers, wholesalers, distributors and others.&lt;/span&gt;&lt;/div&gt; &lt;div&gt;&lt;span&gt;&lt;strong&gt;WHAT IS LEAN SUPPLY CHAIN MANAGEMENT?&lt;/strong&gt;&lt;br /&gt;Lean is how a  properly designed and operated supply chain should function. A lean supply chain  process is one that has been streamlined to reduce and eliminate waste or  non-value added activities along the supply chain flow associated with the  movement of products. Waste can be measured in time, inventory and unnecessary  costs. Value-added activities are those that contribute to efficiently placing  the final product at the customer’s door. The supply chain and inventory  contained in the chain should flow. Any activity that stops the flow or that  touches inventory should create value.&lt;/span&gt;&lt;/div&gt; &lt;div&gt;&lt;span&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt; &lt;div&gt;&lt;span&gt;&lt;strong&gt;WHAT MUST BE DONE TO BE LEAN?&lt;br /&gt;&lt;/strong&gt;Supply chains tend to  accrue waste and non-value added activities for many reasons, both internal to  the company and external. Regaining lean supply chain efficiencies may mean  addressing many of the same issues that created the problems of extra and  unneeded time, inventory and costs. &lt;/span&gt;&lt;/div&gt; &lt;div&gt;&lt;span&gt;The ideal approach is to design the perfect supply chain and fit your  company’s operation onto it. Supply chain management is meant to reduce excess  inventory in the supply chain. It should be demand driven, built on the “pull”  approach of customers pulling inventory in a flow as required, not by suppliers  pushing inventory. Excess inventory reflects the additional time spent within  the supply chain operation. So the perfect supply chain is lean, having removed  wasteful time and inventory.&lt;/span&gt;&lt;/div&gt; &lt;div&gt;&lt;span&gt;A lean supply chain, with the pull, flows back from the store floor through  to purchase orders placed on suppliers. Anything that delays or impedes this  flow must be analyzed as a potential non-value added activity.&lt;/span&gt;&lt;/div&gt; &lt;div&gt;&lt;span&gt;To develop a lean supply chain, firms should:&lt;/span&gt;&lt;/div&gt; &lt;ul&gt;&lt;span&gt;&lt;li&gt;Understand that this is an ongoing, continuous improvement approach as  compared to business process reengineering which can be viewed as a one-time  change.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Gain top management’s commitment. Continuous improvement requires ongoing  support.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Build a multi-discipline team for the project—one that understands lean  supply chain management.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Analyze the total supply chain process, not just the outbound part or just  the inbound part.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Map the process.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Assess for gaps or redundancies in the process that create time, the key  waste.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Avoid cannibalizing the process by just focusing on warehousing or  transportation or other activities instead of studying the entire supply chain  process.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Realize cause-effect impacts. High freight cost, for example, can be a  problem or a symptom. Excess inventory can be a problem or, more often, a  symptom of a problem.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Drive for root causes, not symptoms.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Comprehend the complexity of supply chains with multiple suppliers,  distribution centers and stores.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Appreciate the fundamental impact of international sourcing and shipping on  time and inventory.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Grasp the impact of the organization and culture on supply chain process  design and operation. This can be overlooked as a factor in achieving or not  achieving lean.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Analyze the effect of continuing external events, such as Homeland Security  activities or imports, on lead times and on lean dynamics.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Calculate the risks of the lean supply chain. Reducing inventory frees up  capital; reducing time improves the cash-to-cash cycle. However reducing  inventory, without a properly designed process, removes the comfortable feeling  that accompanies excess inventory and can expose you to the risk of lost sales.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Mitigate risks in the process redesign. This is both good business practice  and meets requirements with Section 404 of the Sarbanes Oxley Act that was  passed after the Enron and other corporate scandals. Sarbanes Oxley requires  that management assess internal controls, with a control framework and process.  Executives must participate, keeping in mind the objective of boosting the  effectiveness and efficiency of supply chain operations as well as the necessity  for making documentation available for management review.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Observe the effect that time has on inventory and on an effective process.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Assess where standardization is feasible and where customizing to specific  customer requirements is needed.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Collaborate with suppliers. It is a requirement, not an option; and it is a  two-way exchange.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Demand supplier performance. It is vital to a lean supply chain operation.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Measure the present process as total cycle time, costs and inventory (both  in dollars and units) and inventory turns.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Integrate the supply chain. Breaks in the flow, both internal and external,  can be pockets of waste.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Identify non-value added activities, their effect and their cause.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Rationalize the process.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Improve the process to drive change.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Streamline the process for unnecessary complexity as well as unnecessary  suppliers and service providers.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Incorporate technology, such as supply chain execution technology, as part  of the process improvement. It is an enabler. Understand where standard ERP and  other software may, or may not, enable a lean supply chain.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Use technology that includes event management and exception management to  enhance management and control. Supply chain complexity increases the need for  event and exception management technology and capability. Event management  focuses on a key event(s) that must happen for process or transaction success.  Exception management focuses on exceptions to what is expected instead of having  to look at everything.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Know that technology cannot overcome process flaws.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Involve your people—employees, suppliers, service providers—to provide input  on present supply chain effectiveness and improvements.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Make the supply chain visible; recognize that blind spots can be areas of  waste.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Recognize the viability of outsourcing as a driver of needed changes. Proper  outsourcing can provide people, process and technology that may otherwise not be  readily available.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Probe for uncertainties that create inventory and other waste. Forecasting  accuracy is one area of opportunity.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Investigate reasons why product does not flow in a more consistent and  predictable manner. Order and shipment releases from suppliers, for example, can  create inbound flows that mitigate time and inventory buffers.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Position inventories at the proper stores and distribution centers. The  right inventory at the wrong facility can result in inter-facility transfers  that add time and extra transport costs and can delay customer order deliveries.  This is a non-value added action that generates waste.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Be open to the changes necessary for the creation of a lean supply chain.  From technology, such as WMS, to a completely redesigned process, significant  change can be expected.&lt;br /&gt;&lt;/li&gt;&lt;li&gt;Include change management in your lean program requirements.&lt;br /&gt;&lt;/li&gt;&lt;/span&gt;&lt;/ul&gt; &lt;div&gt;&lt;span&gt;&lt;strong&gt;CONCLUSION&lt;/strong&gt;&lt;br /&gt;Lean supply chain management is not about  “fixing” what someone else is doing wrong. It is about identifying and  eliminating waste as measured in time, inventory and cost across the complete  supply chain. This requires continuous effort and improvement.&lt;/span&gt;&lt;/div&gt; &lt;div&gt;&lt;span&gt;A lean supply chain can reduce time by 10 to 40%, inventories by 10% to 30%  and costs by 10% to 25%. Continuous improvements can take payback to the upper  range—and beyond. This is a significant benefit to ROI and to the bottom line.&lt;br /&gt;&lt;br /&gt;[Via Email Forward]&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-4204898040606119378?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/4204898040606119378/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=4204898040606119378' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/4204898040606119378'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/4204898040606119378'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/02/creating-and-managing-lean-supply-chain.html' title='Creating and Managing a Lean Supply Chain'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-4504498757232040862</id><published>2008-02-12T14:21:00.000-08:00</published><updated>2010-03-22T21:05:28.111-07:00</updated><title type='text'>Supply Chain Management - An Overview</title><content type='html'>&lt;div  style="font-family:trebuchet ms;"&gt;&lt;span style="font-size:100%;"&gt;If you are not in a company being  impacted right now by Supply Chain Management or by Continuous Replenishment and  do not think that Supply Chain Management affects you, then you are wrong. If it  does impact you now, it will. The concept is appearing in various industries and  is moving to moving into smaller companies. Start to understand what it is, and  what it means to you. Supply Chain Management is a dynamic paradigm driving  through companies. Articles on supply chain management appear in many different  publications, national and international, with different target audience. While  many of the stories relate to large companies who supply large retailers or  grocers, the attention SCM is getting is phenomenal. Add in the global impact of  customers, competitors and suppliers; and the magnitude of the supply chain is  very significant. &lt;/span&gt;&lt;/div&gt; &lt;div  style="font-family:trebuchet ms;"&gt;&lt;span style="font-size:100%;"&gt;What It Is All About. Supply Chain Management is  a reverse of prior practices where manufacturers supplied product to customers  and they wanted to. Now customers tell suppliers how and when they want their  inventory delivered. The driver behind Supply Chain Management is to remove  inefficiencies, excess costs and excess inventories from the supply pipeline  which extends from the customer back through his suppliers and through his  suppliers' suppliers and so on back. By having the program driven by the  customer, it is hoped that inventories, caused by uncertainties and slow  response, will be significantly eliminated. While there are sales incentives to  major suppliers with the carrot of category management or similar programs, the  success of supply chain management rests with logistics. &lt;/span&gt;&lt;/div&gt; &lt;div  style="font-family:trebuchet ms;"&gt;&lt;span style="font-size:100%;"&gt;The Five Key Issues of  Logistics Effectiveness are core to Supply Chain Management-- &lt;/span&gt;&lt;/div&gt; &lt;ul  style="font-family:trebuchet ms;"&gt;&lt;span style="font-size:100%;"&gt; &lt;li&gt;Movement of Product  &lt;/li&gt;&lt;li&gt;Movement of Information  &lt;/li&gt;&lt;li&gt;Time / Service  &lt;/li&gt;&lt;li&gt;Cost  &lt;/li&gt;&lt;li&gt;Integration, both internal and external, both organizations and systems  &lt;/li&gt;&lt;/span&gt;&lt;/ul&gt;&lt;span style=";font-family:trebuchet ms;font-size:100%;"  &gt;Supply chain  management requires a logistics model based on quick order to delivery response.  A model which focuses from vendors' doors through to delivery to customers'  doors. The model must meet the customers' demanding and specific requirements.  It requires organizational flexibility and responsiveness, internal and external  teamwork and demands the use of processes and technology. A common practice  which causes inefficiencies, excess inventories and high costs is  forward-buying. On the surface, it looked like a way to purchase at a low price.  But in reality, this practice is inefficient and results in additional, higher  costs and negative impact throughout the supply chain. Forward-buying strains  the capabilities of suppliers to respond and for the distribution department of  customers to handle the products. It creates an operational and cost  inefficiency for both supplier and customer. By forcing excess sales through the  supply chain, then the hidden costs of manufacturing and distribution valleys,  after the huge peak caused by the forward-buy can be significant. Supply Chain  Management is about what the customer demands. It is not about what the supplier  is capable of doing at present.  &lt;/span&gt;&lt;div  style="font-family:trebuchet ms;"&gt;&lt;span style="font-size:100%;"&gt;The customer requirements may  vary by customer, but they do have certain consistencies to logistics--  &lt;/span&gt;&lt;/div&gt; &lt;ul  style="font-family:trebuchet ms;"&gt;&lt;span style="font-size:100%;"&gt; &lt;li&gt;Quick response to orders from order receipt through shipment to invoicing  &lt;/li&gt;&lt;li&gt;Complete and accurate orders / no backorders  &lt;/li&gt;&lt;li&gt;Delivery windows or appointments  &lt;/li&gt;&lt;li&gt;Special shipment preparation as to packaging, marking, labeling, stenciling,  slip sheets or pallets, etc.  &lt;/li&gt;&lt;li&gt;Bar coding  &lt;/li&gt;&lt;li&gt;EDI  &lt;/li&gt;&lt;li&gt;Carrier selection &lt;/li&gt;&lt;/span&gt;&lt;/ul&gt; &lt;div  style="font-family:trebuchet ms;"&gt;&lt;span style="font-size:100%;"&gt;Effects of Supply Chain  Management. The initial benefits of supply chain management accrue to the  customer, the initiator of his supply chain. He earns the reduction in  inventories by driving out excesses inventories which he must purchase, store  and be responsible for. The impact of supply chain management to the supplier  may be more difficult to classify, initially, as benefits. They may vary, but  may include-- &lt;/span&gt;&lt;/div&gt; &lt;ul  style="font-family:trebuchet ms;"&gt;&lt;span style="font-size:100%;"&gt; &lt;li&gt;Fewer orders initially while the customer draws down excess inventories.  &lt;/li&gt;&lt;li&gt;Small and more frequent orders.  &lt;/li&gt;&lt;li&gt;Vendor carries inventory, not the customer.  &lt;/li&gt;&lt;li&gt;Higher warehousing costs for picking smaller and more orders.  &lt;/li&gt;&lt;li&gt;Higher freight costs for shipping smaller order and more orders.  &lt;/li&gt;&lt;li&gt;Penalties for not meeting the customer's requirements.  &lt;/li&gt;&lt;li&gt;Possible loss of business for not meeting the customer's requirements.  &lt;/li&gt;&lt;li&gt;Additional capital expenditure to satisfy the need for information and  technology to provide the base for SCM responsiveness. Supply chain management  success dictates new ways of doing business for suppliers. There is no  "standard" practice; no "standard" way of doing business. Instead, there is a  practice for each customer.  &lt;div&gt;If a company has one hundred customers, he may have one hundred customer  practices. Adjusting this way challenges traditional management concepts.  Impediments. There are impediments to supply chain success. Emphasis is  presently on the initial customer-supplier link. It is not coordinated through  the supply chain. Instead as the effects ripple through the supply chain, it is  more like a "whisper down the lane" impact, where suppliers are not clear as to  their role and what they must do. Responding to supply chain demands is not  easy. There are issues which must be recognized and dealt with, such as-- &lt;/div&gt; &lt;/li&gt;&lt;li&gt;Accounting Silos. Supply chain management is a leading-edge technique. Yet  the traditional cost measurements used by companies goes back to the Model A.  Meeting Generally Accepted Accounting Principles is one thing; measuring the  costs and benefits of logistics and supply chain management is something quite  different.  &lt;/li&gt;&lt;li&gt;Logistics has a difficulty with having its costs properly identified,  captured and measured properly. Some costs, such as freight, show on the  P&amp;amp;L. Some, such as inventory, show on the balance sheet. And the driver to  supply chain management, service, does not appear on any financial document. As  a result, suppliers may have difficult seeing the cause-effect of supply chain  management to them and the gain-sharing benefits as you progress with it.  Activity-Based Costing is the closest approach to measuring the effects of  supply chain management on an organization. With ABC, you can develop cost  information based on the activities required to the logistics service.  &lt;/li&gt;&lt;li&gt;Functional Silos. Supply chain management is a process which requires  integrated teamwork. Its goal is customer order-response- satisfaction. Yet  traditional organizations, with their responsibilities and goals, may not be  teamwork enhancers. Each function may have its own internal goals which run  counter to effective logistics performance necessary for supply chain management  success. Look at the underlying driver of supply chain management, the customer.  In developing a tailored process to meet the needs of each customer, who is  responsible for it? Sales--after all, it is one of their customers?  &lt;div&gt;Logistics, since they are on the front-line for making supply chain  management work? Manufacturing who must be able to adapt to the dynamics of  point-of-sale or other production drivers? Or consider that the company uses  tools such as MRP to drive its production planning; yet supply chain management  is a pull, not a push approach. How does this shift in a company's practice be  absorbed? Who is responsible then for a company's supply chain management? The  answer is everyone in the company is responsible; yet the organization has often  dictated that one group be responsible. &lt;/div&gt; &lt;/li&gt;&lt;li&gt;Reactionary Practices. Since supply chain management is a process, it takes  time, focus and discipline to make the necessary changes to the way a company  does business. It is not reacting to an order; it is responding to a customer.  "Fighting fires" and other reacting events are anti-process and, while it seems  like it is customer-focused, it is not. Instead reacting to crises and other  emergencies keeps a company for doing what must be done to implement the needed  process for supply chain management. At the end of day of crises, the company is  often no closer to implementing the necessary integrated process.  &lt;/li&gt;&lt;li&gt;Tactical versus Strategic Role for Logistics. Supply chain success depends  upon logistics. To develop the necessary programs for supply chain management,  the logistics organization must be involved in the planning activity from the  beginning. Other groups cannot meet without logistics, decide what logistics  must do, give logistics orders and think there will be supply chain success. If  that approach is used, then the likelihood of meeting the customer requirements  and implementing the technology and teamwork needed will likely not be there.  &lt;/li&gt;&lt;li&gt;Unclear Mission. Supply chain management requires a rethinking of the  company and the logistics mission. Is it customer or is it cost? These can be  conflicting goals. Saying the mission is service, then measuring it by cost can  cause organizations to lose focus on what must be done. Supply chain management  is a new concept and requires a reassessment of the what the company is doing,  where it is going and how it wants to get there.  &lt;div&gt;&lt;b&gt;Conclusion.&lt;/b&gt; Supply chain management is here. It is not about  shipping orders; it is not about making product then pushing it out the door.  Supply chain management is about developing a process to respond to the  different requirements of each customer. Customers are driving suppliers'  practices. Being successful requires logistics effectiveness. Customers,  competitors and vendors are global. This is an exciting challenge and  opportunity for companies who see the potential and make it happen&lt;/div&gt;&lt;/li&gt;[Via Email Forward]&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-4504498757232040862?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/4504498757232040862/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=4504498757232040862' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/4504498757232040862'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/4504498757232040862'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/02/supply-chian-management-overview.html' title='Supply Chain Management - An Overview'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5328628232745164352.post-9101677901002357402</id><published>2008-02-05T22:11:00.000-08:00</published><updated>2010-03-22T21:05:38.891-07:00</updated><title type='text'>5S Practice</title><content type='html'>The 5S Practice is a technique used to establish and maintain a quality environment in an&lt;br /&gt;organisation. The 5S’s are a group of techniques to promote workplace organisation, ensure&lt;br /&gt;adherence to standards and foster the spirit of continuous improvement.&lt;br /&gt;&lt;br /&gt;Principles/ Key Attributes&lt;br /&gt;&lt;br /&gt;To successfully convey the message of 5S across the organisation, achieve total&lt;br /&gt;participation and systematically implement the practice, establishing effective quality&lt;br /&gt;processes as prerequisites for good products and services, the following step-by-step&lt;br /&gt;approach should be adhered:&lt;br /&gt;&lt;br /&gt;· Organisation (Seiri)&lt;br /&gt;The objective of organisation is to get rid of unwanted items by focussing on the core&lt;br /&gt;items that are needed to fulfil the requirements of the job and discard items that are&lt;br /&gt;not needed. This could focus on the elimination of excess inventory affecting,&lt;br /&gt;warehouse space, transportation, labour costs, needed items, and redundant parts, for&lt;br /&gt;example.&lt;br /&gt;&lt;br /&gt;· Neatness (Seiton)&lt;br /&gt;Neatness focuses on efficiency, with the main objective being on how quickly one can&lt;br /&gt;get the things needed and how quickly those things can be put away. This is achieved&lt;br /&gt;through locating a specific place for specific items of a specific quantity, where&lt;br /&gt;needed.&lt;br /&gt;&lt;br /&gt;· Cleaning (Seiso)&lt;br /&gt;The objective of cleaning is to identify abnormalities and areas for improvement. This&lt;br /&gt;is achieved through a combination of cleaning the workplace and at the same time&lt;br /&gt;focusing on the identification of abnormalities or out of control conditions.&lt;br /&gt;&lt;br /&gt;· Standardisation (Seiketsu)&lt;br /&gt;The objective of standardisation is to consolidate the first 3 S’s by establishing&lt;br /&gt;standard procedures. This activity is carried out to determine the best work practices&lt;br /&gt;and find ways of ensuring that everyone carries out an individual activity the same&lt;br /&gt;‘best’ way.&lt;br /&gt;&lt;br /&gt;· Discipline (Shitsuke)&lt;br /&gt;The objective of discipline is to sustain improvements and make further&lt;br /&gt;improvements by encouraging effective use of the ‘Check-Act-Plan-Do’ cycles. This is&lt;br /&gt;achieved through strict adherence to current improvements and the development of an&lt;br /&gt;environment for future improvements.&lt;br /&gt;&lt;br /&gt;The Impact on functional Activities&lt;br /&gt;&lt;br /&gt;The approach embodied with 5S will effect everyone and everything within an organisation.&lt;br /&gt;The technique of 5S begins with a promotion plan for the sole purpose of promoting the&lt;br /&gt;establishment of the 5S’s. This incorporates everyone within the organisation from the&lt;br /&gt;highest level to shop floor level consisting of a blame-free environment. To instil all&lt;br /&gt;viewpoints at each level a steering committee is formulated and is responsible for the&lt;br /&gt;implementation of 5S.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;The next stage is Awareness Training focusing on the dissemination of the 5S plan and its&lt;br /&gt;objectives and incorporating suggestion schemes for the ‘buy-in’ of all employees. An&lt;br /&gt;Internal Audit highlighting areas for improvement.&lt;br /&gt;The scope of activity for the implementation of the 5S technique may incorporate every area&lt;br /&gt;within your organisation or focus on specific areas. Primarily, while incorporating the 5S’s this&lt;br /&gt;will include:&lt;br /&gt;· Disposal of Equipment&lt;br /&gt;· Disposal of Documentation&lt;br /&gt;· Signboard Strategy Team&lt;br /&gt;Environmental Turbulence Indicators&lt;br /&gt;· Intensity of Competition&lt;br /&gt;· Dynamic Customer Requirements&lt;br /&gt;· Supply Chain Turbulence&lt;br /&gt;&lt;br /&gt;Agile Capabilities Index&lt;br /&gt;· Product&lt;br /&gt;· Process&lt;br /&gt;· People&lt;br /&gt;· Operational&lt;br /&gt;· Organisational&lt;br /&gt;&lt;br /&gt;Risks&lt;br /&gt;The major problem with change is ‘buy-in’ from all levels of personnel. This includes shop&lt;br /&gt;floor personnel who will predominantly encompass the ownership of change on the shop&lt;br /&gt;floor and implement actual change on the surrounding area and to the processes&lt;br /&gt;themselves.&lt;br /&gt;&lt;br /&gt;Further, risks include the initial expense of equipment to start cleaning and for the&lt;br /&gt;dissemination of information in terms of notice boards, posters and stationary and awareness&lt;br /&gt;training.&lt;br /&gt;&lt;br /&gt;A major risk is the lack of discipline and maintenance of the 5S technique, effectively letting&lt;br /&gt;all the good work drop due to a lack of monitoring and keeping on top of the situation.&lt;br /&gt;&lt;br /&gt;Benefits&lt;br /&gt;Implementing the 5S technique will have major benefits on an organisation such as:&lt;br /&gt;· Focus on needed items and the elimination/disposal of unneeded items;&lt;br /&gt;· Cleaner workplace and brighter working environment;&lt;br /&gt;· Employee empowerment through ownership;&lt;br /&gt;· Single-point tooling, one of everything;&lt;br /&gt;· Set point locations for needed items;&lt;br /&gt;· Understanding by all of the implications of the 5S Technique due to open channels of&lt;br /&gt;communication.&lt;br /&gt;&lt;span style="font-size:78%;"&gt;Source:The 5S Improvement Handbook, Productivity Europe&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5328628232745164352-9101677901002357402?l=aktview.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://aktview.blogspot.com/feeds/9101677901002357402/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=5328628232745164352&amp;postID=9101677901002357402' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/9101677901002357402'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5328628232745164352/posts/default/9101677901002357402'/><link rel='alternate' type='text/html' href='http://aktview.blogspot.com/2008/02/5s-practice.html' title='5S Practice'/><author><name>AKT</name><uri>http://www.blogger.com/profile/04462821512674059691</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>
