CPP FL Extract IC CPP Core Models Transform

  • Slides: 21
Download presentation

Проект CPP FL Extract IC CPP Core Models Transform FL Load IC Intermediate solution

Проект CPP FL Extract IC CPP Core Models Transform FL Load IC Intermediate solution Target solution Copyright 2018 Accenture. All rights reserved.

Окружения, данные и цикл разработки SQL SAS Dev Test HANA Dev/Unit A few records

Окружения, данные и цикл разработки SQL SAS Dev Test HANA Dev/Unit A few records Test Integration/ System 3 Month Data Test-Pre. Prod Pre-Production Copyright 2018 Accenture. All rights reserved. Production UAT Full Data

Адаптация тестового процесса SELECT field FROM A (SELECT * FROM A WHERE &condition) A

Адаптация тестового процесса SELECT field FROM A (SELECT * FROM A WHERE &condition) A FULL OUTER JOIN B FULL OUTER JOIN ON A. key=B. key (SELECT * FROM B WHERE &condition) B WHERE &condition; ON A. key=B. key; SELECT %precise. Format. Comparison(field, fmt=n) %general. Table. Merge(key=%STR(&t 1. . key=&t 2. . key), align. Data=&True. ); Copyright 2018 Accenture. All rights reserved.

Адаптация тестового процесса Environment Data Test Level Dev A few records Unit Test 3

Адаптация тестового процесса Environment Data Test Level Dev A few records Unit Test 3 Month (low) Integration System Pre-Prod Full (Production) Copyright 2018 Accenture. All rights reserved. Dev QA Regression UAT Production Team(s) Smoke Special Business OPS/TBD

Тестирование производительности Modelling performance SAS vs HANA 70 60 50 40 30 20 10

Тестирование производительности Modelling performance SAS vs HANA 70 60 50 40 30 20 10 0 Filtering Sorting SAS Copyright 2018 Accenture. All rights reserved. Grouping HANA (VIEW) Merging

Тестирование производительности 120 Execution performance SAS vs HANA 1 месяц за 40 часов 100

Тестирование производительности 120 Execution performance SAS vs HANA 1 месяц за 40 часов 100 80 17 лет за две недели 60 40 20 0 Copyright 2018 Accenture. All rights reserved. SAS SAP HANA

Приемочное тестирование Data 201508 201509 201510 201511 201512 201601 201602 201603 201604 201605 201606

Приемочное тестирование Data 201508 201509 201510 201511 201512 201601 201602 201603 201604 201605 201606 201607 201608 201609 201610 201611 201612 SAS 21 177 485 3, 656 3, 808 3, 913 4, 032 4, 145 4, 241 4, 335 4, 502 4, 582 4, 675 4, 793 4, 878 4, 975 5, 106 HANA 21 183 499 3, 750 4, 058 4, 203 4, 339 4, 455 4, 552 4, 646 4, 814 4, 894 4, 987 5, 105 5, 190 5, 286 5, 417 Diff Rel 0 -6 -14 -94 -250 -290 -307 -310 -311 -312 -312 -311 Copyright 2018 Accenture. All rights reserved. 0. 00% -3. 39% -2. 89% -2. 57% -6. 57% -7. 41% -7. 61% -7. 48% -7. 33% -7. 17% -6. 93% -6. 81% -6. 67% -6. 51% -6. 40% -6. 25% -6. 09% ABS 0 6 14 94 250 290 307 310 311 312 312 312 311

Вопросы CONTACTS Дмитрий Чернов Accenture Test Lead Dmytro. Chernov@Accenture. com Copyright 2018 Accenture. All

Вопросы CONTACTS Дмитрий Чернов Accenture Test Lead Dmytro. Chernov@Accenture. com Copyright 2018 Accenture. All rights reserved.

Wavelete Transform Wavelet Transform Wavelet Transform Wavelet TransformWavelete Transform Wavelet Transform Wavelet Transform Wavelet Transform
Extract Subclass Extract Superclass and Extract Hierarchy BYExtract Subclass Extract Superclass and Extract Hierarchy BY
Extract A Extract B 16 144 39 ExtractExtract A Extract B 16 144 39 Extract
FOURIER TRANSFORM BDG51 1 FOURIER TRANSFORM FOURIER TRANSFORMFOURIER TRANSFORM BDG51 1 FOURIER TRANSFORM FOURIER TRANSFORM
Test Struct cpp Test Struct cpp include iostreamTest Struct cpp Test Struct cpp include iostream
CPP Training Block 4 and 5 1 CPPCPP Training Block 4 and 5 1 CPP
CPP Ericsson Connectivity Packet Platform Mikael Agnevik CPPCPP Ericsson Connectivity Packet Platform Mikael Agnevik CPP
Test Struct cpp Test Struct cpp include iostreamTest Struct cpp Test Struct cpp include iostream
Temp Conv cpp 13 Temp Conv cpp includeTemp Conv cpp 13 Temp Conv cpp include
Exception cpp Exception cpp include iostream using namespaceException cpp Exception cpp include iostream using namespace
Variable cpp 5 Variable cpp include iostream usingVariable cpp 5 Variable cpp include iostream using
Variable cpp Variable cpp include iostream using namespaceVariable cpp Variable cpp include iostream using namespace
3 1 oo 2 cpp oo 3 cpp3 1 oo 2 cpp oo 3 cpp
main cpp character cpp Menu Route h keymain cpp character cpp Menu Route h key
Status of the CPP Outline Organization CPP kickoffStatus of the CPP Outline Organization CPP kickoff
Haldin Coffee Extract Products Haldins Tea Extract ProductsHaldin Coffee Extract Products Haldins Tea Extract Products
Knowing your extract OMAM Read this extract andKnowing your extract OMAM Read this extract and
Beetle Boy Fiction Extract The extract of BeetleBeetle Boy Fiction Extract The extract of Beetle
Defining Extract and Scan Scope Concept Defining ExtractDefining Extract and Scan Scope Concept Defining Extract
Datawarehouse Workflow ETLP Extract Transform Load Provide ArchiveDatawarehouse Workflow ETLP Extract Transform Load Provide Archive