If you are struggling with the amount of data you have to process every day you came to the right place.
DB Software Laboratory provides unique business intelligence software to a large range of world class companies and has established an exceptional track record for delivering complete, end to end integration solutions.
Every customer, client and partner receives the highest quality of service and the most innovative and effective solutions and products that have been field tested by our own consultant teams.
All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.
Look at the MS SQL Server code below and think what it will return
declare @x varchar(10) set @X='1245-XMCD-GTH' select Right(substring(@X,charindex('-',@X)+1,charindex('-',@X,charindex('-',@X)+1)-charindex('-',@X)-1),2)
Hint: There result is last two characters of a middle part -‘CD’
Now answer those two questions
How long did it take you to figure out the result? What is the chance of writing wrong code or getting an error? Can you apply same function to a text file, Oracle table or in fact any table?