OrangeScape Developer Community

A community for Application Developers on OrangeScape's Platform-as-a-Service

VM.Hanitha
  • Female
  • Coimbatore
  • India
Share on Facebook Share

VM.Hanitha's Friends

  • timothymnjue
  • Pragati Kyatham
  • Kamal.S
  • Latha Annur Subramaniam
  • Sumathi Rajendran
  • Pushpalatha
  • Balaji Venugopal
  • Santhosh Mahizhan
  • Mani Doraisamy

VM.Hanitha's Discussions

theme changes not reflected
2 Replies

Started this discussion. Last reply by VM.Hanitha Jun 25, 2012.

Error while applying vertical menus.
1 Reply

Started this discussion. Last reply by VM.Hanitha Jun 26, 2012.

Deployment not successful
4 Replies

Started this discussion. Last reply by VM.Hanitha Jun 22, 2012.

Gifts Received

Gift

VM.Hanitha has not received any gifts yet

Give a Gift

 

VM.Hanitha's Page

Profile Information

Job Title
services developer

VM.Hanitha's Blog

Query to find output paths stored in kettle transformation and log file path in kettle jobs

If  Kettle jobs are imported from one server to another server and if kettle working directly or output file saving directory in new server is different.

Kettle job may not  run due to path conflict  or new folders/files will be created in the path as existed in earlier server,  which might not be desirable.

If the number of jobs and transformations are huge it will be very difficult to change all those paths manually.

 If you know id_step_type for…

Continue

Posted on January 30, 2012 at 1:00pm

Syntax to create sequence number and update the same table based on userid order by date desc

Problem:

when uniqueid in  dimension table is a randomly generated alpha numeric value. objectindex() in dimension2.4 depending on uniqueid of table will not work properly.

If incase you had written logic  to generate sequence number for already existing model and it works fine for new records .

But for already existing records if sequence number is not as expected and if data is huge to manually update.

If in case you need a query to generate and…

Continue

Posted on June 27, 2011 at 6:00pm

Capitalize first letters of words - MSSQL

Problem :



In Oracle we have a function called "INITCAP()" which Capitalize first letters of words



When i tried to find a equivalent function INITCAP in MS SQL Server i found only UPPER and LOWER functions. So i came up with something like this as shown below





Solution :



Example : Take FirstName and LastName from User_ table



Query if you are trying to change a single field : Eg : First Name:… Continue

Posted on November 18, 2009 at 3:22pm — 1 Comment

Difference between len() and datalength() mssql

If you want to just get number of characters excluding blanks you would use LEN() function, while in all other cases DATALENGTH().



Please find more information about the same in the following links :



Continue

Posted on October 8, 2009 at 10:28am

Patches for invoking kettle in Dimension 2.4

Problem:



How to invoke kettle from Dimension2.4





Solution:



To invoke kettle from Dimension 2.4, we need to add a patch named js.jar in

${install -drive}$\DimensionServer\server\default\deploy\A-dimension-portal.ear\lib\kettle the folder.

and include the following line in… Continue

Posted on May 21, 2009 at 10:47am

Comment Wall

You need to be a member of OrangeScape Developer Community to add comments!

Join OrangeScape Developer Community

 
 
 

© 2017   Created by OrangeScape Technologies.   Powered by

Badges  |  Report an Issue  |  Terms of Service