abhimita.blogspot.com

Techie's Blog

Wednesday, September 14, 2011. Pivoting columns into rows using Pentaho. Another interesting Pentaho data integration tool's functionality that I played around with is: pivot delimited fields in a file into rows. Following is the description of the test case. This transformation requires pivoting a column in the incoming row into multiple rows. Input and outputs are file based so no database table structure is presented in this section. A@sbcglobal.net,Auto;Mail;Finance. Output will look like. ELSE TRIM(...

http://abhimita.blogspot.com/

OVERVIEW OF abhimita.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

13

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ABHIMITA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

September

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Tuesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.4 out of 5 with 10 reviews

5 star

1

4 star

4

3 star

4

2 star

0

1 star

1

Hey there! Start your review of abhimita.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT ABHIMITA.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

13

SSL

EXTERNAL LINKS

3

SITE IP

74.125.228.236

LOAD TIME

0.265 sec

SCORE

6.2

PAGE TITLE

Techie's Blog | abhimita.blogspot.com Reviews

<META> DESCRIPTION

Wednesday, September 14, 2011. Pivoting columns into rows using Pentaho. Another interesting Pentaho data integration tool's functionality that I played around with is: pivot delimited fields in a file into rows. Following is the description of the test case. This transformation requires pivoting a column in the incoming row into multiple rows. Input and outputs are file based so no database table structure is presented in this section. A@sbcglobal.net,Auto;Mail;Finance. Output will look like. ELSE TRIM(...

<META> KEYWORDS

1 techie's blog

2 input data

3 example

4 b@sbcglobal.net auto

5 intended transformation

6 output data

7 a@sbcglobal.net auto

8 a@sbcglobal.net mail

9 a@sbcglobal.net finance

10 auto 2

CONTENT

Page content here

KEYWORDS ON PAGE

techie's blog,input data,example,b@sbcglobal.net auto,intended transformation,output data,a@sbcglobal.net auto,a@sbcglobal.net mail,a@sbcglobal.net finance,auto 2,mail 1,finance 1,declare,begin,case,end property name,loop,end ;,posted by,abhijit,blogthis

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Techie's Blog | abhimita.blogspot.com Reviews

https://abhimita.blogspot.com

Wednesday, September 14, 2011. Pivoting columns into rows using Pentaho. Another interesting Pentaho data integration tool's functionality that I played around with is: pivot delimited fields in a file into rows. Following is the description of the test case. This transformation requires pivoting a column in the incoming row into multiple rows. Input and outputs are file based so no database table structure is presented in this section. A@sbcglobal.net,Auto;Mail;Finance. Output will look like. ELSE TRIM(...

INTERNAL PAGES

abhimita.blogspot.com

1

Techie's Blog: June 2011

http://www.abhimita.blogspot.com/2011_06_01_archive.html

Wednesday, June 8, 2011. A friend of mine posed a challenging problem today. I will restate the problem using an example. Create table foo (. Val number ,. Insert into foo values (3,1);. Insert into foo values (5,2);. Insert into foo values (12,3);. Insert into foo values (20,4);. We need to write a single SQL to convert data in foo in following form:. 20 - (12 - (5 - 3) ). Here is what I did:. SELECT REPLACE(WM CONCAT(val),',',' ) str. ORDER BY lvl DESC). SELECT MAX(lvl) - 1 lvl. FROM tmp a,.

2

Techie's Blog: Comparison of Cathay Pacific and Singapore Airlines

http://www.abhimita.blogspot.com/2011/07/normal-0-false-false-false-en-us-x-none.html

Sunday, July 17, 2011. Comparison of Cathay Pacific and Singapore Airlines. This is the first time when we traveled to India using airlines other than Singapore Airlines from U.S. West Coast. We used Cathay Pacific whose price per adult ticket came out to be $300 less than SIA. I thought that I would publish a comparison of these two airlines so that others reading this blog might make prudent decision. Both airlines fly B-747 in San Francisco – Hong Kong route during peak of the summer. The seats in San...

3

Techie's Blog: September 2011

http://www.abhimita.blogspot.com/2011_09_01_archive.html

Wednesday, September 14, 2011. Pivoting columns into rows using Pentaho. Another interesting Pentaho data integration tool's functionality that I played around with is: pivot delimited fields in a file into rows. Following is the description of the test case. This transformation requires pivoting a column in the incoming row into multiple rows. Input and outputs are file based so no database table structure is presented in this section. A@sbcglobal.net,Auto;Mail;Finance. Output will look like. ELSE TRIM(...

4

Techie's Blog: Data validations for slowly changing dimension

http://www.abhimita.blogspot.com/2011/05/data-validations-for-slowly-changing.html

Sunday, May 8, 2011. Data validations for slowly changing dimension. If anybody is still not convinced with the benefits of type II dimension, Kimball's book. Is a recommended reading. Primary key in the dimensional table. Uniqueness of active record. If product dimension is maintained as type II dimension then product ID (identifier coming from operational system) may occur may times in the dimension table. All occurrences of records with a product ID needs to be inactive except the last one which s...

5

Techie's Blog: Enabling Oracle's table level constraints in parallel

http://www.abhimita.blogspot.com/2011/05/enabling-oracles-table-level.html

Tuesday, May 17, 2011. Enabling Oracle's table level constraints in parallel. In DW environment often fact tables are inordinately large. They can be easily be several billions and at times hundreds of billions especially in cases where the fact tables contain most granular data. Creating foreign key constraints for such fact tables can be quite a challenge. ALTER TABLE click fact ADD CONSTRAINT click fact prod fk FOREIGN KEY (product sid) REFERENCES product dim(product sid) ;. FROM CLICK FACT a,. Yepits...

UPGRADE TO PREMIUM TO VIEW 8 MORE

TOTAL PAGES IN THIS WEBSITE

13

OTHER SITES

abhimetals.com

Abhimetals

Brass Studs And Rivets. C651 Bolts,Nuts and Washers. Brass Washer Base Screw. HexLag Screws and Hanger Bolts. Lock Type Break Screws. Pip and Serrated Screws. Railway Screws and Bolts. Steel Knurling Insert and Knurling Screw. Hex and Square Bolts. Steel Hex and Square Bolts. Brass Hex and Square Bolts. Stud and Grub Screws. THE MOST COMPREHENSIVE MANUFACTERING GROUP OF FASTENERS PRODUCTS. For Better Design And Quality Guarantee. We don't just produce. We produce peace of Mind.

abhimir.blogspot.com

Lonely People

This thing,they call it blog,goes out to all the lonely people waiting for someone or something. To all the lonely people,you are not alone. not anymore. April 21, 2009. But all that I have told is what I do, not who I am. So I will start again. My name is A. Why did I start with my name? Does my name define me? If my name was something else, would I have been a different person altogether? Come to me, my friend,. I will hold you tight. When you are not up to your mark,. When you are in dark,. Come to me...

abhimirchi.com

Site Unavailable

This site is currently unavailable.

abhimishra.blogspot.com

Story Teller...

Sunday, February 08, 2015. Why the Aam Aadmi went for the party. Almost all the exit polls have predicted a comfortable win for the Aam Aadmi Party in the Delhi elections, and for those who believe them, the Modi-Shah magic is likely to fail in mini-India when the results are announced on February 10. Assuming that the results will be on the line of the exit polls, the question is what happened? During the 49 days the AAP was in power, they managed to gain the trust of the lower income group. And eve...

abhimishra987.blogspot.com

ABHISHEK

abhimita.blogspot.com

Techie's Blog

Wednesday, September 14, 2011. Pivoting columns into rows using Pentaho. Another interesting Pentaho data integration tool's functionality that I played around with is: pivot delimited fields in a file into rows. Following is the description of the test case. This transformation requires pivoting a column in the incoming row into multiple rows. Input and outputs are file based so no database table structure is presented in this section. A@sbcglobal.net,Auto;Mail;Finance. Output will look like. ELSE TRIM(...

abhimjoshi.blogspot.com

Abhishek Joshi

A new way to learn programming. All the way. Let me introduce myself. A bit about me. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Birthday: 21 SEP 1986. Ut enim ad minim...

abhimjoshi.wordpress.com

Asp.Net, C#.Net, .Net Framework, Javascript – Abhishek Joshi | A new way to learn programming. All the way.

AspNet, C#.Net, .Net Framework, Javascript – Abhishek Joshi. AspNet, C#.Net, .Net Framework, Javascript – Abhishek Joshi. September 1, 2008. Store and retrieve file with SQL Server. Store file in SQL Server. FileStream objFileStream = new FileStream(“[Path of File]”, FileMode.Open);. Byte[] Data = new byte[objFileStream.Length];. ObjFileStream.Read(Data, 0, Convert.ToInt32(objFileStream.Length) ;. SqlCommand objCommand = new SqlCommand(“Bytes Insert”);. ObjCommand.Connection = objConnection;. Microsoft&#...

abhimmobilier.com

Index of /

Apache/2.4.7 (Ubuntu) Server at www.abhimmobilier.com Port 80.

abhimod.com

abhimod

abhimol-unitech.blogspot.com

UniTech - News, Technology & Sports

UniTech - News, Technology and Sports. Enter your search terms. Tuesday, April 24, 2007. MY 7 QUESTIONS FOR THE WEEK. ANSWERS TO PREVIOUS WEEK'S QUESTIONS. 4) Graphical User Interface. Questions for the week 22-Apr-2007 to 28-Apr-2007. Question this week are in the pics format). Recognise these cricketing personalities. Sunday, April 22, 2007. SACHIN and SAURAV OUT! For the first time in 17 years that the stars of the selectors of the Indian Cricket have turned on its head. How? ONE MAN PER POST! MY 7 QU...