IND

US

TR

Y S

ER

VE

D

BNFS

OV

ER

VIE

WB

US

INE

SS

NE

ED

SS

OL

UT

ION

S

Helped Client Realize 50% Reduction In The Turnaround Time for Data Movement

Key Challenges Faced and Mitigation provided in the Migration

• CreationofbackuptablestoreducetheexcessivetimetakentoupdateNetezzatablesindeltaloads

• RemovalofduplicatestageinDatastageETLjobsbeforeloadingthedataintothetargettablestotargetthelackofaprimarykeyconceptinNetezzadatabase

• AnewauditprocesstovalidateloadedrecordsattheETLlevelandconfirmthecountofdatarowsinthetargetdatabasetables

• ChangeinthedatatypeinthetablesandETLlevelsothatNetezzaidentifiesspecialcharacterupdatesthedatabasewithcorrectdata

Atos Syntel’s client is a Fortune 500 global payments, network and travel company, with a worldwide network that processes millions of merchant transactions daily, in more than 200 countries.

Theclientwantedtoimproveitsinformationdeliverysystemwithahigh-performancedatawarehouseforoptimizationandimprovedperformance,whileensuringaffordabilityanddeliveringanenhancedend-userexperience.However,theywerewitnessinganexponentialincreaseinthenumberofactiveusers,data,andqueriesonDB2,therebydelayingsystemresponse,whichwasaffectingend-userreportgeneration.

ToincreasetheefficiencyinaDB2system,itwouldbenecessarytoimplementcomplexqueries,complexschemas,indexes,aggregates,andadvancedpartitions;howevertheclientwasfacingarchitecturalconstraintswiththisapproach.Theyneededtocollaboratewithastrongtechnologypartnerwithexperienceintheirmarketnichetodelivertherightsolutioninashortturnaroundtime.

Astheinitialstepinthisproject,Atos SyntelconductedanimpactanalysistogaugetheimplicationofamigrationfromDB2toNetezza.Thestudyrevealedthat:— DB2deploymentonadvancedserverswereunableprovideoptimalperformance— Hugeamountofdatawasrepeatedlyexchangedbetweenthestorageandmemory

Atos Syntelsetupahigh-performancedatawarehouseandreplacedtheexistingIBMDB2withIBMNetezzaforquickerprocessing.Toensureseamlessmigrationandsuccessfulrolloutofthesolutionourteamworkedintandemto:— AnalyzeanddeterminetheperformanceofNetezzawithaProofofConcept— ChangetheexistingETLjobs,scripts,views,queries,andfunctionstomakeitNetezza

compliant— Reverseengineerclientarchitecturetomakeitplatform-independentandNetezza-

centric— DevelopnewNetezza-compliantSQLqueriesandETLjobsusingIBMInfoStage,as

definedintheclient’sbusinessrequirementsforimprovedTAT,scriptsandSQLqueries— Migrateend-to-enddatafromDB2toNetezzausingexistingandnewlydeveloped

InfoStageETLjobs— Implementperformanceimprovementtechniquestoacceleratetheloadsandreducethe

responsetimetohalf— AssesstheneedtochangeadministrationattributesofETLjobs— Performpostimplementationtestingandvalidationfordataaccuracy

For more information, visit us at www.atos-syntel.net © 2018, SYNTEL INC.

DIF

FE

RE

NT

IAT

OR

SB

EN

EF

ITS

Data Warehouse Remediation for an Analytics and Reporting Application

Why Us?

• AleadingglobalITandKPOserviceprovider

• Morethan24officesinNorthAmerica,EuropeandAsia

• Flexibleandsuccessfulglobaldeliverymodeltodelivercost-effectivesolutions

The Atos Syntel Advantage

— Createdsolutionacceleratorwhichisautilitytriggertoautomaticallyuploadhistoricaldata,countthenumberofrowsandsendanautomatednotificationoferror/success

— In-houseNetezzapracticeteamtosupportandrapidlyresolveanyissuesfacedinthemigrationprocess

— Seamlessmigrationandintegrationwiththeexistingreportingsystems—minimizingthechangerequiredfordownstreamapplications

Results

— Byimplementingour solution the client was able to achieve its goals of providingfasterservicetoitsclientsandhandlethelargenumberofactiveuserswithoptimizedperformance

— Theclientalsorealized50%reductionintheturnaroundtimeforETLloads— Extensivecoordinationandclosecollaborationwithalltheimpactedtechnologyand

businessteamsandcriticalsupportgroupstoestablishaninformationflowsystem,andenablesmoothdelivery