Insurance Client S2 DE082 ETL Technical Specification v14.doc



Search



Home



Saved

0

38 views



Join

RELATED TITLES

0

Insurance Client S2 DE082 ETL Technical Specification v14.doc



Uploaded by Neeharika Uppalapati



Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News



Documents

1

of 62

Applying So�ware

 

ETL Testing

ETL Test-Case Template

 Search document

Solvency II



Sign In

Upload



213560877.doc

Sheet Music

Insurance Client Logo

INSURANCE CLIENT Solvency II

ETL Technical Technical Specification S pecification For Increment 2

Deliverable Reference

DE082

Version

1.14

Status

Signed-Off

ile !a"e

213508!!.doc

#ast $dit Date

18"04"2012

Sign up to vote on this title



Useful

 Not useful







Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

ETL Testing




 Search document

Solvency II





213560877.doc

Sheet Music

Docu"ent Revie% !a"e

&itle

Date

$ites% Lad

C&I E'L Lead

(and%i (and%irr )a*ala )a*ala+,r +,rone one

Soluti Solution on rc%it rc%itect ect

&ar Carter

//lication Delier* &anager

Sue order

I& Solution rc%itect

Docu"ent '((roval !a"e

&itle

Si)nature

&ar Carter


Version *istory 'ut+or,s-

Version

R !u"ber

'"end"ents/Reason

Date

drian ag*

1.0

Initial #u,lication #u,lication

0"11"2011

drian ag*

1.1

/dated 6it% 6it% t%e S# E2E (econciliation

10"11"2011

drian ag*

1.2

/dated ,ased on reie6 reie6 co++ents

15"11"2011

drian ag*

1.3

/dated 6it% 6it% t%e reie6 co++ents fro+ &ar Carter

1"11"2011

drian ag*

1.4

dded t%e reconciliations reconciliations for SO(CE 1-S# and SO(CE 1-'DS7 /dated t%e Section on general E'L

18"11"2011

drian ag*

1.5

/dated 6it% 6it% t%e reie6 30"11"2011  co++ents fro+ #aul '%o+son Sign up9agstaff toagstaff vote on this title Stuart $a*nes Sara% 9 and t%e I& offs%ore tea+. Not useful  Useful /dated 6it% t%e c%anges fro+ t%e C(#(231 - SCS #rocess

D





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

ETL Testing




 Search document

Solvency II





213560877.doc

Sheet Music

Docu"ent Revie% !a"e

&itle

Date

$ites% Lad

C&I E'L Lead

(and%i (and%irr )a*ala )a*ala+,r +,rone one

Soluti Solution on rc%it rc%itect ect

&ar Carter


Sue order

I& Solution rc%itect

Docu"ent '((roval !a"e

&itle

Si)nature

&ar Carter


Version *istory 'ut+or,s-

Version

R !u"ber

'"end"ents/Reason

Date

drian ag*

1.0

Initial #u,lication #u,lication

0"11"2011

drian ag*

1.1

/dated 6it% 6it% t%e S# E2E (econciliation

10"11"2011

drian ag*

1.2

/dated ,ased on reie6 reie6 co++ents

15"11"2011

drian ag*

1.3

/dated 6it% 6it% t%e reie6 co++ents fro+ &ar Carter

1"11"2011

drian ag*

1.4

dded t%e reconciliations reconciliations for SO(CE 1-S# and SO(CE 1-'DS7 /dated t%e Section on general E'L

18"11"2011

drian ag*

1.5

/dated 6it% 6it% t%e reie6 30"11"2011  co++ents fro+ #aul '%o+son Sign up9agstaff toagstaff vote on this title Stuart $a*nes Sara% 9 and t%e I& offs%ore tea+. Not useful  Useful /dated 6it% t%e c%anges fro+ t%e C(#(231 - SCS #rocess

D





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views



Sign In

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

ETL Testing




 Search document

Solvency II



Upload

213560877.doc

Sheet Music

drian ag*

1.

Section !.2 6as 6as u/dated to list 12"12"2011 t%e :o,s 6%ic% are /o/ulating t%e +etrics ta,le

drian ag*

1.10

;et
drian ag*

1.11

/dated for defect 31 /dated as /er C(251 C%anged t%e reconciliations notifications as /er defect 38

31"01"2012

drian ag*

1.12

/dated as /er defect 4247 Section 3.! u/dated to not co+/are t%e count on SO(CE 1-S# reconciliation Section 4..3 u/dated to refer to t%e correct filena+e

0"02"2012

drian ag*

1.13

Load Coer Sna/s%ot 6as u/dated for t%e /artitioning c%anges > defect =440"=441

2"03"2012

drian ag*

1.14

S# (eference (eference data +etrics re+oed > defect =1

18"04"2012

Reference Docu"ents Ref !u"ber

Docu"ent

Version

#ocation of docu"ent

(D1

SII<(1.0<3.0<D300 Si Single Integration La*er<1.10.doc?

1.10

@uic(

(D2

SII<(1.0<2.<D300 1.0 SCS<&a//ing<unctional
(D3

IS(CE CLIE'
28

(D4

Dist
0.3

E+ail fro+ &ar Carter

(D5

SCS ta,les 02 ?ls

02

E+ail fro+ Leon an $eerden

@uic(

Sign @uicup (to vote on this title  Useful  Not useful







Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Upload

Sign In

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News



Documents Solvency II





1

of 62

Applying So�ware

 

ETL Testing


 Search document



213560877.doc

Sheet Music

&'#$  !&$!&S

1 INTRODUCTION

1.1 Purpose.................................................................................................................................... 1.2 Scope for Increment 2.................................................................................................................. 1.3 SIL Tables.................................................................................................................................... 1.4 External Dependences................................................................................................................

2 INCRE"ENT 2 ETL #ROCESSIN$ CO"#ONENT O%ER%IE&

2.1 SIL !"er"e# Da$ram............................................................................................................... 2.2 TDS to TDS !"er"e# Da$ram.............................................................................................. 2.3 &ob Summar' Table.....................................................................................................................

( INTERNAL RECONCILIATION )UILD

3.1 &obs co"ered n t)s secton........................................................................................................ 3.2 Structure and *appn$s............................................................................................................... 3.2.1 Data Input.............................................................................................................................. 3.2.2 Mapping................................................................................................................................. 3.2.3 Data Output........................................................................................................................... 3.3 SE(22 + S!,-E 1/TDS -econclaton................................................................................... 3.3.1 Description............................................................................................................................ 3.3.2 Job Flow................................................................................................................................ 3.3.3 Build Specification................................................................................................................. You're Reading a Preview 3.4 SIL((2S!,-E 10TDS0$$re$ate0and0compare.................................................................. 3.4.1 Description............................................................................................................................ Unlock full access with a free trial. 3.4.2 Job Flow................................................................................................................................ 3.4.3 Build Specification................................................................................................................. 3. SIL((1-eadS!,-E 1Incomn$ .............................................................................................. Download With Free Trial 3..1 Description............................................................................................................................ 3..2 Job Flow................................................................................................................................ 3..3 Build Specification.................................................................................................................  3. SE(23 + S!,-E 1/SP -econclaton................................................................................... Sign up to vote on this title 3.!.1 Description............................................................................................................................  Useful  Not useful 3.!.2 Job Flow................................................................................................................................ 3.!.3 Build Specification................................................................................................................. 3.7 SIL((3S!,-E 10SP0$$re$ate0and0compare..................................................................





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Upload

Sign In

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News








1

of 62

Applying So�ware

 

ETL Testing


 Search document



213560877.doc

Sheet Music

4. SIL((0Load0SP0Errors.......................................................................................................... 4..1 Description............................................................................................................................ 4..2 Job Flow................................................................................................................................ 4..3 Build Specification................................................................................................................. 4. SIL((0Load0SP0&ournal0and0Detal0Errors........................................................................ 4.!.1 Description............................................................................................................................ 4.!.2 Job Flow................................................................................................................................ 4.!.3 Build Specification................................................................................................................. 4.7 SIL((70E2E0$$re$ate0and0compare...................................................................................... 4.".1 Description............................................................................................................................ 4.".2 Job Flow................................................................................................................................ 4.".3 Build Specification.................................................................................................................

- TDS TO TDS SNA#S.OT CO"#ONENT )UILD

.1 &obs co"ered n t)s secton........................................................................................................ .2 Structure and *appn$s............................................................................................................... .2.1 Data Input.............................................................................................................................. .2.2 Mapping................................................................................................................................. .2.3 Data Output........................................................................................................................... .3 SE(18 + TDS o"er Snaps)ot for S!,-E 1........................................................................... .3.1 Description............................................................................................................................ .3.2 Build Specification................................................................................................................. .4 SE(1% + TDS o"er Snaps)ot for S!,-E 2........................................................................... .4.1 Description............................................................................................................................ .4.2 Build Specification................................................................................................................. . SE(2( + TDS Dal' *easures..................................................................................................... You're Reading a Preview ..1 Description............................................................................................................................ ..2 Build Specification................................................................................................................. Unlock full access with a free trial. . TDS((10et0SS0for0S!,-E 1........................................................................................... .!.1 Description............................................................................................................................ Download With Free Trial .!.2 Job Flow................................................................................................................................ .!.3 Build Specification................................................................................................................. .7 TDS((20et0SS0for0S!,-E 2........................................................................................... .".1 Description............................................................................................................................  Sign up to vote on this title .".2 Job Flow................................................................................................................................ .".3 Build Specification.................................................................................................................  Useful  Not useful .8 T-((1 + S)ared ontaner for lass Structure loo5ups.......................................................... .#.1 Description............................................................................................................................ &ontainer Flow.............





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News








1

of 62

Applying So�ware

 

ETL Testing


 Search document



213560877.doc

Sheet Music

!.2.1 Data Input.............................................................................................................................. !.2.2 Mapping................................................................................................................................. !.2.3 Data Output........................................................................................................................... .3 SE(17 + Load Transacton Tables.............................................................................................. !.3.1 Description........................................................................................................................... !.3.2 Job Flow............................................................................................................................ !.3.3 Build Specification................................................................................................................

! $ENERAL ETL #ROCESSIN$

7.1 Sc)eduln$................................................................................................................................... ".1.1 '2' (econciliation Batc) Flow............................................................................................. ".1.2 SI* Batc) Flow...................................................................................................................... ".1.3 +DS Batc) Flow.................................................................................................................... ".1.4 Batc) I,ple,entation Details............................................................................................... 7.2 &ob -ecordn$.............................................................................................................................. 7.3 Error *ana$ement....................................................................................................................... 7.4 *antann$ reference data.......................................................................................................... 7. Parameter *ana$ement.............................................................................................................. 7. 6le S'stem Structure................................................................................................................... 7.7 6TP 6le locatons for De" and Test............................................................................................

You're Reading a Preview Unlock full access with a free trial.

Download With Free Trial




Useful

 Not useful







Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News



Documents

1

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

1 Intro34ction 11 #4rpo5e

'%e /ur/ose of t%is docu+ent is to /roide t%e detailed leel tec%nical s/ecification for t%e E'L co+/onents in sco/e of Incre+ent 2 of t%e IS(CE CLIE' Solenc* II (elease 0.1 solution. includes /arts of t%e Single Integration La*er ASILB and t%e load to t%e Sna/s%ot and &easures 'a, t%e 'ransactional Data Store A'DSB. '%e docu+ent 6ill descri,e t%e flo6 of t%e E'L /rocesses 6% ,e used ,* t%e ,uild tea+ 6%en deelo/ing E'L :o,s.

12 Scope for Increment 2

'%e diagra+ ,elo6 is an oerie6 of all t%e E'L co+/onents 6it%in sco/e of (elease 0.1 and t%os t%e red ,o?es are in sco/e of incre+ent 2.






Useful

 Not useful







Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views



Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II



Sign In

Upload

ETL Testing


 Search document



213560877.doc

Sheet Music

1( SIL Ta6le5

'%ere are a nu+,er of S@L Serer ta,les t%at are used ,* t%e E'L :o,s during t%e /rocessing. sc%e+a is ,eing +aintained se/aratel* fro+ t%e +ain 'DS sc%e+a and 6ill also ,e t%e su,:ect of  control.

1* E7ternal Depen3encie5 '%e follo6ing e?ternal de/endencies %ae ,een identified •

DataStage Serer aila,ilit*

•

Data,ase aila,ilit*

•

Source ile aila,ilit*






Useful

 Not useful







Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News



Documents

1

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

2 Increment 2 ETL #roce55in8 Component Overvie9 21 SIL Overvie9 Dia8ram

'%e diagra+ ,elo6 s%o6s t%e tec%nical sco/e for t%e SIL for Incre+ent 2 ,roen do6n into nu+,e ll E'L :o,s 6it%in t%e solution 6ill ,e /refi?ed 6it% SE ASolenc* II E'LB. '%ere is one :o, seuenc SO(CE 1 - S# E2E reconciliation and t6o :o, seuences for t%e SO(CE 1-S# and SO(CE reconciliations.

I!& 6

S-# (econciliation 1iles

S$021

S-# E2E (econciliation






Useful

 Not useful







Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II





ETL Testing




 Search document

213560877.doc

Sheet Music

SIFFto TDS I!&

SI11 1iles

S$015

S$016

S$017

SI11 1ile (ecei/t

SI11 1ile )alidation

Load 'ransaction 'a,les

(e:ected SI11 1iles

(e:ected SI11 (ecords

S$018

S$020

'DS Co0er Sna/s%ot for -IS

'DS Dail* &easures A-IS

S$013

S$020

'DS Co0er Sna/s%ot for 5E(IS

'DS Dail* &easures A5E(ISB

Incre"ent 2

2( o6 S4mmary Ta6le Fo, u+,er Aa+eB SE018

You're Reading a Preview

Descri/tion

Unlock full access with a free trial.

Fo, Seuence used to get t%e SCS and 'DS
Download With Free Trial SE020

Fo, Seuence used to calculate t%e E# a +easures and load t%e 'DS
SE01

Fo, Seuence to get t%e SCS and useful  Useful used  Not 'DS




Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News








1

of 62

Applying So�ware

 

ETL Testing


 Search document



213560877.doc

Sheet Music

( Internal Reconciliation )4il3 (1 o65 covere3 in thi5 5ection

'%e diagra+ ,elo6 s%o6s t%e :o, seuences and :o,s used to reconcile data ,et6een SO(CE 1 S# and ,et6een SO(CE 1 and 'DS.






Useful

 Not useful







Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Upload

Sign In

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News



Documents

1

Solvency II





of 62

Applying So�ware

 

ETL Testing


 Search document



213560877.doc

Sheet Music

In(ut !a"e

Descri(tion

SIL<'DS<#'
sed to asse+,le a 'DS<#OLICG<'( record /rior to trans+itting t%e SInnnnn fil

SIL<'DS<#C
sed to asse+,le a 'DS<#OLICG
SIL<'DS<(C
sed to asse+,le a 'DS<#OLICG<(EIS(CE
SIL
sed to asse+,le a S# Detail re trans+itting t%e IEnnnnnn file.

(22 "appin8 4a((in)

Descri(tion

"


(2( Data O4tp4t ut(ut !a"e (econciliation Success file

(econciliation Error file


Descri(tion Download With Free Trial

9ill contain t%e results of t%e reconciliati success. Eac% ro6 %as //er (ID count a  Aa+ountB Sign up to vote on this title

Useful  Not useful 9ill  contain t%e results of t%e reconciliati error. Eac% ro6 %as //er (ID count and Aa+ountB





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

((2 o6 Flo9

((( )4il3 Specification DataSta)e co"(onent

DataSta)e co"(onent ty(e/na"e

Descri(tion

Seuence na+e

SE022
Fo, ctiit*

SIL002SO(CE Download With Free TrialFo, 6%ic% aggregates and co+/a 1<'DS<ggregate
E?ecute Co++and

C&D

'%is :o, seuence e?ecutes t%e :o aggregates t%e data fro+ SO(C t%e data fro+ SIL 6%ic% 6as sent You're Reading a Previewand co+/ares t%e results. It notifie /ersons res/onsi,le on t%e succe Unlock full access with a free trial. of t%e reconciliation /rocess.

C%ecs if t%e reconciliation erro  If *es t%etitle reconciliation is Signe+/t*. up to vote on this successful.Not useful Useful

 otification ctiities

otifications



otif* t%e /ersons res/onsi,le success or t%e failure of t%e recon





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Upload

Sign In

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

(* SIL,,2SOURCE 1:TDS:A88re8ate:an3:compar (*1 De5cription

'%is :o, aggregates t%e data fro+ SO(CE 1 and t%e data sent to 'DS and co+/ares t%e results.

(*2 o6 Flo9

(*( )4il3 Specification You're Reading a Preview DataSta)e co"(onent Fo, na+e

Unlock full access with a free trial. DataSta)e co"(onent ty(e/na"e Descri(tion


SIL002SO(CE 1<'DS<ggregate
'%is :o, aggregates and co+/are fro+ SO(CE 1 and data sent reads and :oins t%e SO(CE 1 da  grou/ing on t%e u/ Signaggregates up to vote on,* this title calculates t%e ro6 count and t%e s  Useful  Not useful Aa+ountB does t%e sa+e for t%e ' and t%en co+/ares t%e results. It Hsuccess or an Herror file ,ased o





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Upload

Sign In

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

DataSta)e co"(onent


Descri(tion

nu+,er for t%e current run A:o, /a In/ut Stage

ODC Connector ASIL<'DS<(C
(eads all records fro+ t%e SIL<'DS<(C
In/ut Stage

DataSet

'%e dataset containing t%e SO inco+ing data. '%e :o, 6%ic% 6rite dataset is detailed on t%e ne?t sec

#rocessing Stage

unnel

nions t%e H#C and H(C record

#rocessing Stage

Foin

Foins t%e 'DS data on t%e #olic

#rocessing Stage

Colu+n ;enerator

Stage 6%ic% adds a colu+n Aro flo6 6it% t%e alue H1. '%e aggreg t%en ,e used to su+ on t%is colu+ calculate t%e count of ro6s.

#rocessing Stages

ggregator

ggregates ,* grou/ing on //er Unlock full access with a free trial.calculating su+Aro6cntB and su+A

#rocessing Stage

Foin


#rocessing Stage

ilter


Foins t%e aggregation results fr 1 and 'DS ,ased on t%e //er (

ilters t%e reconciliation results  t%e counts Signco+/aring up to vote on this title and su+s fr SO(CE 1 Inco+ing dataset +in useful  Useful  Not counts and su+s fro+ t%e SO(C Hdro//ed records 6it% 'DS and re records to eit%er success or error





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Upload

Sign In

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

(- SIL,,1Rea3SOURCE 1Incomin8 (-1 De5cription '%is :o, :oins and aggregates t%e data fro+ SO(CE 1 and 6rites it to a dataset.

(-2 o6 Flo9

(-( )4il3 Specification


DataSta)e co"(onent


Fo, na+e

SIL001(eadSO(CE 1Inco+ing

In/ut Stage

ODC Connector ASIL
Descri(tion


'%is :o, :oins and aggregates t SO(CE 1 and 6rites it  into a Sign6%ic% up to vote on this title can ,e used in t%e reconcili /rocess.  Useful  Not useful

(eads all records fro+ t%e SIL




Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

DataSta)e co"(onent


Descri(tion

#ara+eters

Serial nu+,er

'%e seuence 6%ic% is /art of t%e for 6%ic% t%e reconciliation /roces

D a+e

Data,ase na+e

D ser

Data,ase user na+e

D #ass6ord

Data,ase /ass6ord

(/ SE,2( + SOURCE 1SA# Reconciliation (/1 De5cription

'%is :o, seuence re/resents t%e oerall flo6 needed to /erfor+ t%e SO(CE 1-S# (econciliatio co+/onents and actiities in t%e seuence are detailed ,elo6 in t%e ,uild s/ecification ta,le.

(/2 o6 Flo9 You're Reading a Preview Unlock full access with a free trial.





Useful

 Not useful







Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views



Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

ETL Testing

 


 Search document

Solvency II



Sign In

Upload



213560877.doc

Sheet Music

DataSta)e co"(onent


Descri(tion

Co++and

otification ctiities

e+/t*. If *es t%e reconciliation successful. otifications

otif* t%e /ersons res/onsi,le success or t%e failure of t%e recon /rocess.

Include t%e reconciliation out/ut fi attac%+ent. #ara+eters

Seuence nu+,er

'%e seuence 6%ic% is /art of t%e for 6%ic% t%e reconciliation /roces

D a+e

Data,ase na+e

D ser

Data,ase user na+e

D #ass6ord

Data,ase /ass6ord

E+ail addresses

'%e e+ail addresses of t%e /eo/l notified in case of errors

You're1:SA#:A88re8ate:an3:compar Reading a Preview (! SIL,,(SOURCE Unlock full access with a free trial.

(!1 De5cription


'%is :o, aggregates t%e data fro+ SO(CE 1 and t%e data sent to S# and co+/ares t%e results.

(!2 o6 Flo9

Sign up to vote on this title K



Useful

 Not useful







Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Upload

Sign In

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

(!( )4il3 Specification DataSta)e co"(onent


Descri(tion

Fo, na+e

SIL003SO(CE 1
'%is :o, aggregates and co+/are fro+ SO(CE 1 and data sent reads and :oins t%e SO(CE 1 da aggregates ,* grou/ing on t%e u/ calculates t%e su+ Aa+ountB doe for t%e S# data and t%en co+/ar results. It 6rites a Hsuccess or an ,ased on t%e result of t%e co+/ar contains t%e reconciliation results.

In/ut Stage

ODC Connector ASIL
(eads all records fro+ t%e SIL
In/ut Stage

DataSet

'%e dataset 6it% t%e SO(CE data. '%e dataset is ,eing 6ritten SIL001 :o,.

#rocessing Stages

ggregator

ggregator stage 6%ic% grou/s ,* (ID and calculates su+Aa+ountB

#rocessing Stage

Foin

#rocessing Stage

ilter

Out/ut Stages

Seuential iles

#ara+eters

Seuence nu+,er


Foins t%e aggregation results fr

Unlock full access with a free trial.1 and S# ,ased on t%e //er (

Download With Free Trialilters t%e reconciliation results

co+/aring t%e su+s fro+ SO(C S# and redirects t%e records to success or error out/uts.  Sign up to vote on this title '6o seuential files 6%ic% 6ill c Not useful  Useful  reconciliation results.

'%e seuence 6%ic% is /art of t%e





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views



Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

ETL Testing

 




 Search document

Solvency II



Sign In

Upload

213560877.doc

Sheet Music

* SOURCE 1 + SA# E2E Reconciliation )4il3 *1 o65 covere3 in thi5 5ection

'%e diagra+ ,elo6 s%o6s t%e Fo, Seuences and t%e Fo,s used to reconcile t%e data /osted ,* S t%e data fro+ SO(CE 1 sent to 'DS and S#.

I!& 6

S-# (econciliation 1iles

SI#00

Load S-# #ostings

SI#005

SI#006

Load S-# Errors

Load S-# )alidation Errors AFournal and DetailB

SI#007

-ggregate and Co+/are

S$021  S' $2$ Reconciliation



Download With Free Trial *2 Str4ct4re an3 "appin85

*21 Data Inp4t

 Useful Descri(tion

In(ut !a"e i


d t

il

t i i



 Not useful S#

ti

f

t% S





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Upload

Sign In

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News



Documents

1

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

*22 "appin8 4a((in)

Descri(tion

Source files to SIL
Si+/le one-to-one +a//ing fro+ t%e file ta,les. '%e +a//ings can ,e found in t%e S 'arget &a//ing s/reads%eet t%at acco+/a docu+ent A(D8B.

*2( Data O4tp4t ut(ut !a"e

Descri(tion

SIL
'a,le used to ca/ture S# /ostings fro+ reconciliation data. '%e ta,le structure is do in t%e functional design docu+ent referenc (D1.

SIL
'a,le used to ca/ture S# errors fro+ t reconciliation data. '%e ta,le structure is do in t%e functional design docu+ent referenc (D1.

You're Reading a Preview SIL
'a,le used to ca/ture S# re:ected :our fro+ t%e S# reconciliation data. '%e ta,le is docu+ented in t%e functional design doc referenced Download With Free Trial as (D1.


SIL
'a,le used to ca/ture S# re:ected deta fro+ t%e S# reconciliation data. '%e ta,le  is docu+ented in t%e Sign up to vote onfunctional this title design doc referenced as (D1.  Useful  Not useful





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

*( *(2 2 o6 o6 Flo9 Flo9

*(( *(( )4il3 )4il3 Specifica Specification tion DataSta)e co"(onent


Descri(tion

Seuence na+e

SE021
'%is :o, seuence 6aits for to a//ear and t%en triggers t%e reconciliation /rocess. It gets t nu+,er contained 6it%in t%e deletes t%e data fro+ t%e SIL S for t%is serial nu+,er Aif t%e file loaded /reiousl*B loads t%e d SIL S# ta,les aggregates t% fro+ S# and t%e data fro+ S co+/ares t%e results. If t%e rec is successful deletes t%e data S# ta,les. If t%e reconciliatio successful notifies t%e /erson res/onsi,le for future inestiga

'%e seuence 6ill ,e sc%edule  +ulti/le in a ,atc% as t%e Sign up to vote onti+es this title +ore t%an a set of files needed useful  Usefulreconcile  Notand t%e* 6ill ,e /roc ,* one.





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views



Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II



Sign In

Upload

ETL Testing


 Search document



213560877.doc

Sheet Music

DataSta)e co"(onent


Descri(tion

E?ecute Co++and

C&D

Scri/t 6%ic% deletes t%e rec sa+e filena+e fro+ t%e S# ta SIL.

Fo, ctiit*

SIL004
Fo, 6%ic% loads t%e S# #

Fo, ctiit*

SIL005
Fo, 6%ic% loads t%e S# E

Fo, Fo, ct cti iit it* *

SIL0 SIL00< 0
Fo, Fo, 6%i 6%ic% c% load loads s t%e t%e S# S# Fo Detail Errors.

Fo, ctiit*

SIL00!
Fo, 6%ic% aggregates and S# and SO(CE 1 SIL data

E?ecute Co++and

C&D

C%ecs if t%e reconciliation

E?ecute Co++and

C&D

If t%e reconciliation is succe arc%ies and t%en deletes ,ot% source files and t%e records fro S# ta,les.

otifications

otif* t%e /ersons res/onsi success or t%e failure of t%e reconciliation /rocess.

otification ctiities

Include t%e reconciliation out/ an attac%+ent. #ara ara+eters ers

Sourc urce ile Locati ation D a+e D ser D #ass6ord

'%e /at% to t%e source  files Sign up to vote on this title Data,ase na+e  Useful  Not useful Data,ase user na+e Data,ase /ass6ord





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

** **2 2 o6 o6 Flo9 Flo9

**( **( )4il3 )4il3 Specifica Specification tion DataSta)e co"(onent


Descri(tion

Fo, na+e

SIL004
'%is :o, loads t%e aiennnnn into t%e corres/onding SIL ta,l

In/ut Stage

Seuential ile

(eads t%e source file to ,e 6it%in t%e current ,atc%.

#rocessing Stage

Co/* stage

Co/ies t%e in/ut to t%e out/ to-one +a//ing for all t%e field

Out/ut Stage

ODC Connector Stage

Loads t%e SIL
#ara+eters

Source ile Location

'%e /at% to t%e source files

Source filena+e seuence

#art of t%e filena+e used to files

D a+e D ser D #ass6ord

Data,ase na+e Data,ase user na+e  Sign up to vote on this title Data,ase /ass6ord  Useful  Not useful





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

*-( )4il3 Specification DataSta)e co"(onent


Descri(tion

Fo, na+e

SIL005
'%is :o, loads t%e aiennnnn into t%e corres/onding SIL ta,l

In/ut Stage

Seuential ile


#rocessing Stage

Co/* stage

Co/ies t%e in/ut to t%e out/

Out/ut Stage


Loads t%e SIL
#ara+eters

Source ile Location

'%e /at% to t%e source files

Source filena+e seuence

#art of t%e filena+e used to files Data,ase na+e

D a+e D ser


D #ass6ord Unlock full access with a free trial.

Data,ase user na+e Data,ase /ass6ord


*/ SIL,,/:Loa3:SA#:o4rnal:an3:Detail:Error5 */1 De5cription




Useful

 Not useful

'%is :o, loads t%e SIL






Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News



Documents

1

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

*/( )4il3 Specification DataSta)e co"(onent


Descri(tion

Fo, na+e

SIL00
'%is :o, loads t%e :ournal alidation errors data Aaiennnnnne01.datB into t%e corres/onding SIL ta,les.

In/ut Stage

Seuential ile


#rocessing Stage

&odif* Stage

#erfor+s su,string of t%e f c%aracters of t%e in/ut and /l alues into a ne6 colu+n

#rocessing Stage

ilter stage

C%ecs t%e alues in t%e n added in t%e +odif* stage an t%e records as follo6s H05 K Fournal (ecord H10 K Detail (ecord

Out/ut Stage

ODC ConnectorYou're Stage Reading a Preview Unlock full access with a free trial.

Out/ut Stage

ODC Connector Download Stage With Free Trial

#ara+eters

Source ile Location Source filena+e seuence

Loads t%e SIL
Loads t%e SIL
 to t%e Sign up to'%e vote/at% on this titlesource files



Useful #art ofNot t%euseful filena+e used to files Data,ase na+e





Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views



Sign In

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

1

Download



News



Documents

of 62

Applying So�ware

 

Solvency II



Upload

ETL Testing


 Search document



213560877.doc

Sheet Music

*!2 o6 Flo9

*!( )4il3 Specification DataSta)e co"(onent


Fo, na+e

SIL00!
Descri(tion

You're Reading a Preview '%is :o, aggregates and co+/ares

Unlock full access with a free trial. fro+ S# and SO(CE 1-SIL. It rea

:oins t%e S# data aggregates on t nu+,er and calculates t%e ro6 coun Download With Free Trial su+Aa+ountB does t%e sa+e for t%e and t%en co+/ares t%e results. It 6r Hsuccess or an Herror flag ,ased on  of t%e co+/arison. Sign up to vote on this title In/ut Stage


Useful Not useful '%is stage reads t%e data fro+ t%

SIL




Home



Saved



Top Charts



Books



Audiobooks



Magazines



News



Documents



Sheet Music



Upload

Sign In

Join



Search



Home



Saved

0

38 views

Sign In

Upload

Join

RELATED TITLES

0







Top Charts



Books



Audiobooks



Magazines










Save

Embed

Share

Print

Download



News



Documents

1

of 62

Applying So�ware

 

Solvency II





ETL Testing


 Search document



213560877.doc

Sheet Music

DataSta)e co"(onent


Descri(tion

filters t%e records on t%e serial nu+, outgoing
Co/* stages

'%ree co/* stages used to rena+ colu+ns to ,ring t%e+ to t%e sa+e n t%e funnel stage. ee/ onl* t%e Seri +ount colu+ns.

#rocessing Stage

unnel stage

unnel stage to union t%e S# #o Errors data.

#rocessing Stage

ggregator Stage

ggregator stage 6%ic% 6ill grou/ o ,elo6 e*s and 6ill su+Aa+ountB - (ecord)alidated - Co+/an*You're Reading a Preview - S# Download With Free Trial - 'reasur*    - #osting<e* '%is is /erfor+ed to ,ring t%e SIL da   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion out/ut lin. Out/ut Stages Seuential ile  seuential file 6%ic% 6ill contain first line to indicate t%e reconciliation successful or not. It 6ill also contain reconciliation figures A,ot% count an a+ountB. 9ill ,e read fro+ inside t% seuence. #ara+eters ile Location '%e /at% 6%ere t%e out/ut file is to , Source filena+e serial nu+,er #art of t%e filena+e used to identif* D a+e Data,ase na+e D ser Data,ase user na+e D #ass6ord Data,ase /ass6ord You're Reading a Preview Unlock full access with a free trial. Download With Free Trial Sign up to vote on this title  Useful  Not useful    Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents Solvency II   1 of 62 Applying So�ware   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music - TDS to TDS Snap5hot Component )4il3 -1 o65 covere3 in thi5 5ection '%e diagra+ ,elo6 s%o6s t%e Fo, Seuences and t%e Fo,s used to /o/ulate t%e 'DS Coer Sna/ t%e 'DS Dail* &easures ta,les. or 'DS Coer Sna/s%ot t%ere are se/arate :o, seuences for ea source s*ste+s SO(CE 1 and SO(CE 2 ,ut t%e* are calling t%e sa+e :o,s e?ce/t for t%e deter+ination of t%e SCS 6%ere t%e logic and t%e fields used are co+/letel* different. or t%e 'DS &easures t%ere is onl* one :o, seuence. '%e :o,s and :o, seuences 6%ic% are Hs%ared ,* SO and SO(CE 2 6ill %ae a /ara+eter to s/ecif* t%e Source S*ste+ and t%e alue of t%is /ara+ete ,e /art of t%e dataset filena+e 6%ere a//ro/riate. You're Reading a Preview Unlock full access with a free trial. Download With Free Trial Sign up to vote on this title  Useful  Not useful    Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music In(ut !a"e Descri(tion /re+iu+ data. -22 "appin8 4a((in) Descri(tion 'DS #olic* 'ransaction to 'DS Coer Sna/s%ot and 'DS Dail* &easures &a//ing t%at details %o6 t%e fields in t%e s ta,les are +a//ed into t%e 'DS Coer Sna Dail* &easures 'a,les. '%is can ,e found in t%e Source to ' arget & s/reads%eet t%at acco+/anies t%is docu+e -2( Data O4tp4t ut(ut !a"e 'DS Coer Sna/s%ot Descri(tion '%is ta,le %olds coer data at t%e lo6es leel toget%er 6it% t%e SCS code a//ro/ria You're Reading a/olic*. Preview#olic* ID allo6s lining ,ac u/ /olic* of 6%ic% t%is coer is a /art. Unlock full access with a free trial. 'DS Dail* &easures '%is ta,le %olds nearned #re+iu+ (es and Earned Download With Free Trial #re+iu+ AE#B data for eac% coer. It is recalculated on a sc%eduled ,as dail* or +ont%l*B and t%e date of calculation recorded. &easures are alid onl*on t%at d up toinvote on this titleis %eld on t%is dail* Sign c%ange E# and #( facilitateUseful ad-%oc calculation. Not useful     Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Upload Sign In Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion SO(CE 1 source s*ste+. Fo, ctiit* 'DS001<;et '%e :o, 6%ic% gets t%e SCS for 1 data. Fo, ctiit* 'DS003 '%e :o, 6%ic% loads t%e 'DS Co ta,le. '%e alue of t%e Source s*st /ara+eter +ust ,e s/ecified as HSO #ara+eters Source S*ste+ S/ecifies t%e Source S*ste+ Aei SO(CE 1 or SO(CE 2B t%e dat loaded fro+. sed in t%e load :o,. -* SE,1' + TDS Cover Snap5hot for SOURCE 2 -*1 De5cription '%is :o, seuence e?ecutes t%e :o,s 6%ic% /o/ulate t%e 'DS Coer Sna/s%ot for t%e SO(CE 2 s You're Reading a Preview s*ste+. -*2 )4il3 Specification Unlock full access with a free trial. Download With Free Trial DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Seuence na+e SE01<'DS Descri(tion  Sign'%is up to vote on this title seuence e?ecutes t%e :o, /o/ulate t%eNot 'DS Coer Sna/s%ot useful  Useful SO(CE 2 source s*ste+.   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music -- SE,2, + TDS Daily "ea54re5 --1 De5cription '%is :o, seuence e?ecutes t%e :o,s 6%ic% /o/ulate t%e 'DS Dail* &easures for t%e SO(CE 1 a SO(CE 2 source s*ste+s. '%e :o, seuence %as a /ara+eter to s/ecif* t%e Source S*ste+ and it is /assed to t%e e?ecuted :o,s. '%e transfor+ation logic does not de/end on t%e source %ence t% need to ,uild se/arate :o,s or :o, seuences for eac% sou rce s*ste+ as in t%e 'DS Coer Sna/s% --2 )4il3 Specification DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion Seuence na+e SE020<'DS '%is seuence e?ecutes t%e :o, /o/ulate t%e 'DS Dail* &easures f SO(CE 1 and SO(CE 2 source Fo, ctiit* 'DS004 '%e :o, 6%ic% calculates t%e dai Fo, ctiit* 'DS005 '%e :o, 6%ic% loads t%e 'DS Da ta,le. You're Reading a Preview #ara+eters Source S*ste+ S/ecifies t%e Source S*ste+ Aei SO(CE 1 or SO(CE 2B t%e dat loaded fro+. sed in t%e load :o,. Unlock full access with a free trial. Download With Free Trial -/ TDS,,1:$et:SCS:for:SOURCE 1 Sign up to vote on this title -/1 De5cription  Useful '%is :o, 6ill +a/ t%e SO(CE 1 #olic* 'ransaction data to SCS.  Not useful    Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Upload Sign In Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music -/( )4il3 Specification DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion Fo, na+e 'DS001<;et '%is :o, gets t%e Distri C%annel and t%e (is Cla t%en using t%ese it gets and t%e ot%er IDs in t%e C Structure &a/. It generat surrogate e* 6%ic% is to as a /ri+ar* e* for t%e s ta,le and 6rites t%e data dataset using HOer6rite In/ut Stage ODC Connector Stage AD<'DS<#OLICG<'(SC'IO '%is stage reads t%e data 'DS<#OLICG<'(SC ta,le filtered ,* t%e sourc euals HSO(CE 1. '%is s/ecified in a /ara+eter. onl* ne6 transactions sin load ,* reading t%e ro6s /olic* You're Reading a Preview Unlock full access with a free trial. In/ut Stage ODC Connector Stage AD In/ut Stage ODC Connector Stage AD #rocessing Stage Loou/ '%is stage reads t%e Dist C%annel (ules ta,le. Sel t%e colu+ns to ,e used in loou/.  '%is stage Sign up to vote on this titlereads t%e (is (ules ta,le. Select onl* t% Not useful  Useful  colu+ns to ,e used in t%e Loou/ stage to get t%e C   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion to-target +a//ings. dd t condition for t%e date Asna date ,et6een start date a dateB to +ae sure t%at t% returns t%e latest record. t%e /artitioning +et%od o reference lin to HEntire. Container S%ared Container AC'(<;E' E+,ed t%e na+ed s%ared container. &atc% t%e in/u out/ut lins. '%e s/ecifica t%e s%ared container can in t%e section 5.8 ,elo6. #rocessing Stage Co/* Stage AC#<'O<';' Co/* stage to dro/"ren colu+ns as a//ro/riate. E colu+n 6ill ,e dro//ed o it is a good /ractice to us stage ,efore t%e target st /lace%older to +ae t%e f c%anges easier to ,e i+/ Out/ut Stage Dataset ile ADS<'DS #ara+eters Dataset Location You're Reading a Preview Dataset 6%ic% %olds t%e / records to ,e 6ritten in ta,le 'DS  Useful '%e /at% 6%ere t%e datas Not useful  stored. Data,ase na+e   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music -! TDS,,2:$et:SCS:for:SOURCE 2 -!1 De5cription '%is :o, 6ill +a/ t%e SO(CE 2 #olic* 'ransaction data to SCS. -!2 o6 Flo9 You're Reading a Preview Unlock full access with a free trial. Download With Free Trial Sign up to vote on this title  -!( )4il3 Specification Useful  Not useful    Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views  Sign In Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   ETL Testing ETL Test-Case Template  Search document Solvency II  Upload  213560877.doc Sheet Music DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion euals HSO(CE 2. '%is s/ecified in a /ara+eter. onl* ne6 transactions sin load ,* reading t%e ro6s /olic* ODC Connector Stage AD '%is stage reads t%e Dist C%annel (ules ta,le. Sel t%e colu+ns to ,e used in loou/. In/ut Stage ODC Connector Stage AD '%is stage reads t%e (is (ules ta,le. Select onl* t% colu+ns to ,e used in t%e #rocessing Stage 'ransfor+er Stage AC#<IELD<&##I;SB se a 'ransfor+er stag t%e reference data to t%re 6%ic% are reference lins t%ree loou/s. Send t%e a colu+ns for eac% loou/ descri,ed in t%e source to +a//ings. You're Reading a Preview Unlock full access with a free trial. Download With Free Trial #rocessing Stage or t%e t%ird loou/ send data 6it% genc* Loou/ AL#   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Upload Sign In Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents Solvency II   1 of 62 Applying So�ware   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion dateB to +ae sure t%at t% returns t%e latest record. t%e /artitioning +et%od o reference lin to HEntire. #rocessing Stage Loou/ AL# '%ird loou/ stage to get C%annel Code. Loou/ s continue 6%en not found C%annel Code s%ould ,e Hnulla,le. '%e loou/ con descri,ed in t%e source-t +a//ings. dd t%e range for t%e date Asna/s%ot da ,et6een start date and e +ae sure t%at t%e loou/ t%e latest record. C%ange /artitioning +et%od on t% reference lin to HEntire. #rocessing Stage unnel AL unnel stage used to u ro6s. #rocessing Stage 'ransfor+er AC#<IELD<&##I;S<(ISB You're Reading a Preview se a transfor+er stag reference data to t%ree ou Unlock full access with a free trial. 6%ic% are reference lins t%ree loou/s. Send t%e a Download With Free Trial colu+ns for eac% loou/ descri,ed in t%e source to +a//ings.  or loou/ se Sign up to vote ont%e thissecond title t%e data 6it% #olic*<u+  Useful  Not useful or t%e t%ird loou/ send data 6it% #olic*<u+,er Coerage   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents Solvency II   1 of 62 Applying So�ware   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion #rocessing Stage Loou/ AL#<(IS Second Loou/ stage (is Class ID. Loou/ s% a re:ect lin to go to t%e n loou/. '%e loou/ condi descri,ed in t%e source-t +a//ings. se t%e /riorit /lus t%e e* fields to sort reference data to ensure %ig%est /riorit* record id i +atc%ed. dd t%e range condition f Asna/s%ot date ,et6een s and end dateB to +ae su loou/ returns t%e latest r C%ange t%e /artitioning + t%e reference lin to HEntir #rocessing Stage Loou/ AL#<(IS You're Reading a Preview Unlock full access with a free trial. Download With Free Trial '%ird loou/ stage to g Class ID. Loou/ s%ould 6%en not found and t%e ( s%ould ,e +ade Hnulla,le loou/ condition is descri source-to-target +a//ing /riorit* colu+n /lus t%e  sort on t%e reference data t%at t%e %ig%est /riorit* re +atc%ed. dd t%e range condition f Asna/s%ot date  ,et6een s Sign up to vote on end this title and dateB to +ae su loou/ returns t%e latest r Not useful  Useful  C%ange t%e /artitioning + t%e reference lin to HEntir   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views  Sign In Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II  Upload ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion Out/ut Stage Dataset ile ADS<'DS Dataset 6%ic% %olds t%e / records to ,e 6ritten in ta,le 'DS #ara+eters Dataset Location '%e /at% 6%ere t%e datas stored. Data,ase na+e D a+e Data,ase ser a+e D SE( Data,ase #ass6ord D #9D Source S*ste+ Sna/s%ot Date &a? /olic* transaction id You're Reading a Preview Unlock full access with a free trial. Download With Free Trial KSO(CE 2 '%e date t%e sna/s%ot is for. '%e +a?i+u+ alue of t% transaction id ,efore t%e c ,atc% run. '%is is to ,e u/ t%e /ara+eter set file fro+ oerall :o, seuence afte of t%e coer sna/s%ot for source s*ste+s.  Signfor up to vote on thisStr4ct4re title -; CTR,,1 + Share3 Container Cla55  Useful  Not useful loo<4p5   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views  Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   ETL Testing ETL Test-Case Template  Search document Solvency II  Sign In Upload  213560877.doc Sheet Music -;2 Container Flo9 -;( )4il3 Specification DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion In/ut Stage ODC Connector Stage AD<'DS '%is stage reads t%e Class Str &atri? ta,le. Select onl* t%e co ,e used in t%e loou/. In/ut Stage ODC Connector StageReading a Preview You're AD<'DS '%is stage reads t%e Class Stru ta,le. Select onl* t%e colu+ns in t%e loou/. Unlock full access with a free trial. #rocessing Stages &odif* Stages A&DG<$DLE<LLB '%ree &odif* stages to +ae null Download With Free Trial   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music -' TDS,,(:Loa3:Cover:Snap5hot -'1 De5cription '%is :o, loads t%e 'DS -'2 o6 Flo9 -'( )4il3 Specification DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion Fo, na+e 'DS003 '%is :o, reads t%e DataSet t%e ;et SCS :o,s and loads it i 'DS In/ut Stage Dataset ADS<'DS You're Reading a Preview Unlock full access with a free trial. Download With Free Trial #rocessing Stage 'ransfor+er A&<'DS Out/ut Stage ODC Connector Stage AD<'DS '%e dataset 6ritten ,* t%e ; se a /ara+eter to s/ecif* t%e s*ste+. 'ransfor+er stage calculate t% +easures as detailed in t%e +a s/reads%eet.  Sign up to vote on this title 9rites to t%e 'DS   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views  Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II  Sign In Upload ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music -1, -1,1 TDS,,*:Calc4late:Daily:"ea54re5 De5cription '%is :o, calculates all t%e Earned #re+iu+ and nearned #re+iu+ (esere dail* +easures. -1,2 o6 Flo9 -1,( )4il3 Specification DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion Fo, a+e 'DS004 '%is :o, reads t%e sna/s%ot transfor+er to calculate t%e +e generates a surrogate e* and data into a dataset. You're Reading a Preview In/ut Stage #rocessing Stage Unlock full access with a free trial. ODC Connector Stage AD<'DS '%is reads t%e 'DS   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion #ara+eters Dataset Location '%e /at% 6%ere t%e datasets a D a+e Data,ase na+e D SE( Data,ase ser a+e D #9D Data,ase #ass6ord Source S*ste+ '%e source s*ste+ na+e. Calculation Date '%e date t%e calculations are + -11 -111 TDS,,-:Loa3:Daily:"ea54re5 De5cription '%is :o, loads t%e 'DS -112 o6 Flo9 You're Reading a Preview Unlock full access with a free trial. Download With Free Trial -11( )4il3 Specification DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Fo, a+e 'DS005 Sign up Descri(tion to vote on this title  Useful   Not useful '%is :o, reads t%e DataSet t%e Calculate &easures :o, an   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion /ara+eteriMed stored /rocedur s%ould ,e called as Hefore S@ ODC Stage. '%ere are t6o ac 6%ic% need to ,e done - - #ara+eters Dataset Location c%ec if t%e data is alre loaded for t%e calculati and if so ,ased on t%e /ara+eter eit%er dro/ /artition and create it a si+/l* add data to t%e calculation date dro/ t%e /artitions 6%ic older t%an 3 calendar + /lus one 6ee e?ce/t /artitions for t%e last d +ont% as 6e need to  +ont%s rolling of %istor end-+ont% figures '%e /at% 6%ere t%e datasets a D a+e You're Reading a Preview Data,ase na+e D SE( Unlock full access with a free trial. Data,ase ser a+e D #9D Data,ase #ass6ord Source S*ste+ Download With Free Trial '%e source s*ste+ na+e. Sign up to vote on this title  Useful  Not useful    Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views  Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware ETL Testing   ETL Test-Case Template  Search document Solvency II  Sign In Upload  213560877.doc Sheet Music / #olicy .ea3er  Up3ate to Increment 1 SIL TDS =o6 /1 o65 covere3 in thi5 5ection '%is section s%o6s t%e u/date needed to ,e done to t%e incre+ent 1 SE01! :o, to load t%e 'DS # $eader ta,le. S$017 Load 'ransaction 'a,les (e:ected SI11 (ecords You're Reading a Preview Unlock full access with a free trial. /2 Str4ct4re an3 "appin85 Download With Free Trial /21 Data Inp4t Sign up to vote on this title  In(ut !a"e  Useful Descri(tion  Not useful e6 in/ut 'DS<#olic*<$eader '%ere is one ne6 in/ut to ,e added to t%   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Solvency II   Applying So�ware   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music /2( Data O4tp4t ut(ut !a"e Descri(tion e6 out/ut 'DS<#olic*<$eader '%ere is one ne6 out/ut to add to t%is :o $eader ta,le. '%is ta,le %olds /o lic* %eade data. /( SE,1! + Loa3 Tran5action Ta6le5 /(1 De5cription '%is is t%e Incre+ent 1 :o, 6%ic% needs to ,e +odif*ing to include t%e 'DS #olic* $eader loou/ a /o/ulation. '%e flo6 and t%e s/ecification ,elo6 refer onl* to t%e c%anges needed to ,e i+/le+ent '%is c%ange needs to ,e i+/le+ented in t%e :o, called 'DS004Load#olic*'ransactionDS rat%er t% 'DS00#olic*<'ransactionLoadD as t%e  constraint reuires data to ,e loaded in t%e #olic* $ ,efore it is loaded to t%e #olic* 'ransaction. /(2 o6 Flo9 You're Reading a Preview Unlock full access with a free trial. Download With Free Trial Sign up to vote on this title  Useful  Not useful    Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views  Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   Solvency II  Sign In Upload ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music DataSta)e co"(onent DataSta)e co"(onent ty(e/na"e Descri(tion t%e #olic* ID. If t%e loou/ fails go to t%e re:e continue 6it% t%e Surrogate e ;enerator stage. If t%e loou/ is successful go t unnel stage. #rocessing Stage Surrogate e* ;enerator A#olic* IDB 9%en t%e loou/ to t%e #olic not successful t%is stage gene ne6 alue to ,e used as a #oli #rocessing Stage Co/* Co/ies t%e in/ut to t6o out/ unnecessar* colu+ns on eac% #rocessing Stage unnel nions t%e records Out/ut Stage ODC Connector 9rites to t%e 'DS #olic* $e You're Reading a Preview Unlock full access with a free trial. Download With Free Trial Sign up to vote on this title  Useful  Not useful    Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music ! $eneral ETL #roce55in8 '%is section descri,es t%e ;eneral E'L /rocessing ele+ents t%at su//ort t%e functional as/ects of s*ste+ descri,ed in t%e sections a,oe. !1 Sche34lin8 '%is section s%o6s t%e ,atc% sc%edule and flo6 for ,ot% SIL N 'DS. It t%en also /roides details a, t%is 6ill ,e i+/le+ented 6it%in DataStage. !11 E2E Reconciliation )atch Flo9 You're Reading a Preview Unlock full access with a free trial. Download With Free Trial Sign up to vote on this title  Useful  Not useful    Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Upload Sign In Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Solvency II   Applying So�ware   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music !12 SIL )atch Flo9 You're Reading a Preview Unlock full access with a free trial. Download With Free Trial Sign up to vote on this title   Useful  Not useful '%e diagra+ a,oe %ig%lig%ts t%e Incre+ent 2 flo6s 6%ic% 6ill ,e /laced inside t%e oerall SIL ,atc   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Upload Sign In Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music !1( TDS )atch Flo9 You're Reading a Preview Unlock full a free '%e diagra+ a,oe %ig%lig%ts t%e Incre+ent 2 access flo6s with 6%ic% 6illtrial. ,e /laced in t%e oerall 'DS atc%. Download With Free Trial !1* )atch Implementation Detail5 '%e ,atc% 6ill ,e i+/le+ented as follo6s • • Sign up to vote on this title 'i+e ased Seuences '%ese 6ill ,e sc%eduled to run in t%e DataStage Sc%eduler  Useful  Not useful  ile ased Seuences '%ese 6ill ,e sc%eduled to run in t%e DataStage Sc%eduler %o6eer t%e* 6ill ,e controlle   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music !2 o6 Recor3in8 Fo, recording is t%e co+/onent t%at logs infor+ation a,out t%e e?ecuting DataStage :o, suc% as st duration and olu+e of data /rocessed and 6%et%er t%e :o, co+/leted successfull* or failed. Eac% :o, in DataStage is identified ,* a uniue ID and eac% e?ecution of a :o, is identified ,* a uni ,atc% nu+,er. atc% nu+,ers +a* ,e t%e sa+e for +ore t%an one :o, for e?a+/le a series of :o, +ae u/ a /rocessing sc%edule. '%e ta,le ,elo6 details t%e E'L Control 'a,les &R#D$! olu"n na"e Data &y(e 9ey Descri(tion Fo, I' #  uniue ID for t%e Fo,  s%ort na+e for t%e :o, to identif* t%e :o, in re/orts Fo, )arc%arA100B Source )arc%arA20B SO(CE 1"SO(CE 2 Fo, )arc%arA200B Descri/tion of t%e :o,. You're Reading a Preview &R#'&*$:$ olu"n na"e Unlock full access with a free trial. Download Trial Data &y(e With Free9ey FO I' atc% I' Fo, I' Descri(tion #  uniue ID for t%e e?ecutio  Sign up to vote on this title  uniue ID for t%e ,atc%  Useful  Not useful  AC'(L   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music t%at deli,eratel* a,ort 6%ile failed is 6%ere t%e :o, 6as forced to ter+inate for e?a+/le s*ste+ failure. &R#$:$4$&RI olu"n na"e Data &y(e 9ey Descri(tion &etric I' #  uniue ID for t%e +etric ,eing recorded Fo, I'  AC'(L<atc% &etric )arc%arA5B &etric code &etric<a+e )arc%arA255B a+e for t%e +etric &etric<)alue )arc%arA100B )alue for t%e +etric &etrics in t%e C'(L You're Reading a Preview • #rocessed file na+e Afull* ualifiedB • #rocess file nu+,er • SiMe of file A,*tesB • (o6 count • inancial 'otal Unlock full access with a free trial. Download With Free Trial • $as% Su+ 'otal • Out/ut file na+e Afull* ualifiedB • Out/ut file siMe A,*tesB Sign up to vote on this title  Useful  Not useful    Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Upload Sign In Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   ETL Testing ETL Test-Case Template  Search document Solvency II    213560877.doc Sheet Music '%e follo6ing ta,le s%o6s t%e :o, seuences and t%e :o,s 6%ic% 6ill record t%e infor+ation to t%e C'(L ob na"e 4 SE003 SO(CE 1001E?tractSO(CE 1Sourceile SE003 SO(CE 1001E?tractSO(CE 1Sourceile SE004 SO(CE 1001Data)alidation SE004 SO(CE 10029rite(e:ectiles (e: in #ol #ol 'D (ec in #ol #ol You're Reading a Preview Unlock full access with a free trial. Download With Free Trial SE005 SO(CE 1001Enric%+entSO(CE 1Inco+ing'a,le Sign up to vote on this title SE005  Useful  Not useful SO(CE 1001LoadS#Out'a,le u+ (ec 'ot u+ Fou Ae 'ot  (ea (ec in #ol #ol <<< (e: (ec in #ol #ol 9ri u+ in 9ri   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   ETL Testing ETL Test-Case Template  Search document Solvency II    213560877.doc Sheet Music ob se;uence na"e SE00 SE010 SE011 SE011 ob na"e 4 (002)alidatesile (ea (ec in #ol #ol (001LoadInco+ing'a,les Loa in #ol #ol SO(CE 2001Data)alidation (e: (ec in #ol #ol SO(CE 20029rite(e:ectiles (ea (ec in #ol #ol (ea (ec in #ol #ol You're Reading a Preview SE012 Unlock full access with a free trial. (002Inco+ing'oDs Download With Free Trial SE012 (00!/dateInco+ing Sign up to vote on this title  Useful  Not useful  (e: (ec in #ol #ol 9ri (ec in #ol   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware   ETL Testing ETL Test-Case Template  Search document Solvency II    213560877.doc Sheet Music ob se;uence na"e ob na"e 4 (ea (ec in #ol #ol <<< SE01! Loa (ec in #ol #ol 'DS008Load(einsuranceContractD (ea (ec in #ol #ol <<< Loa (ec in #ol #ol You're Reading a Preview Unlock full access with a free trial. SE01! 'DS00#olic*'ransactionLoadD Download With Free Trial Sign up to vote on this title  Useful  Not useful  (ea (ec in #ol #ol <<< Loa (ec   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music !( Error "ana8ement  reuire+ent of t%e s*ste+ is to log all errors t%at occur so t%at t%e* can ,e anal*sed and acted o infor+ation to ,e logged includes • '%e E?ecution ID of t%e DataStage :o, t%at rSource 1ed t%e error • '%e Error Code • #rocess or &odule reference to identif* 6%ere in t%e :o, t%e error occurred • Error details. '%e error code defines t%e t*/e of error for e?a+/le Inalid ile or+at and field /roides details for 6%* t%e error 6as generated 9%en recording errors t%e descri/tion +ust /roide full details of t%e error as in t%e e?a+/le a,oe data is recorded in t%e Error Log ta,le. '%e ta,les t%at su//ort Error Lo gging are detailed ,elo6 &R#$RRR ,Staticolu"n na"e Data &y(e 9ey Descri/tion E((O( I' #  uniue c error You're Reading a Preview  s%ort na error e.g.  )alidation Unlock full access with a free trial. E((O( )(C$(2A500B Download With Free Trial E((O( )(C$(2A1000B Sign up to vote on this title  Useful  Not useful  full desc t%e error in suggested  action   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views  Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 of 62 Applying So�ware ETL Testing   ETL Test-Case Template  Search document Solvency II  Sign In Upload  213560877.doc Sheet Music &R#$RRR#< olu"n na"e Error Error<'i+esta+/ Error Fo, Data &y(e Int 9ey Descri/tion # n ID to un identif* t%e eent Date'i+e '%e date a error occur s*ste+ dat E'L serer I' '%e uniue error t%at o  to C'( a,oe  fro+ C'(L  fro+ I' You're Reading aC'(L<'C$ ile<a+e Error AO/tionalB of t%e sour is ,eing /r )arc%arA100B Download With Free Trial )arc%arA500B Sign up to vote on this title  Useful '%e ID for e?ecuting , to t%e C'(L<at ta,le  Not useful Details of t for t%e erro  or data a and +a//i t%is is t%e n t%e re:ect f   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music $rror odes $rror #evel $rror ode $rror !a"e $rror Descri(tion Lo6 001 Dateor+atError  date in c%aracter for+at can not ,e c a Date data t*/e Lo6 002 u+,eror+atError  nu+,er in c%aracter for+at can not conerted to a u+eric Lo6 003 Dateti+eor+atError  date"ti+e in c%aracter for+at can no conerted to a Dateti+e Lo6 004 otullError  +andator* field is null Lo6 005 inancial)alidationError '%e financial c%ec on a source file t% alue euals detail total failed $rror 'lert rocess n e+ail alert 6ill go to t%e user grou/ Ainancial.S*ste+sInterfacesu.Insurance Clientgrou/.co /roiding t%e follo6ing infor+ation • Error Code • Error S%ort a+e • Fo, E?ecution ID • Fo, a+e • Error 'i+esta+/ • ilena+e • Error Details You're Reading a Preview Unlock full access with a free trial. Download With Free Trial Onl* one e+ail is to ,e sent /er e?ecuting :o,. Sign up to vote on this title  Useful  Not useful    Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Upload Sign In Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print Download  News  Documents 1 Solvency II   of 62 Applying So�ware   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music ara"eter !a"e Descri(tion /roc.alert '%e e+ail address of 6%ere alert e+ails sent. tds.%ig% '%e large future date used ,* '*/e II %is folder.root (oot folder of t%e E'L /rocess file s*ste+ folder.sil.rece/tion (ece/tion folder for SIL data /rocessing folder.sil.arc%ie rc%ie folder for co+/leted source files /rocessing folder.sil.re:ect (e:ect folder for re:ected source files for /rocessing folder.sil.out Out/ut folder for generated SIL files folder.sil.static older for static files for SIL /rocessing folder.sil.scri/ts older for an* s%ell scri/ts used ,* SIL folder.sil.te+/ You're Reading a Preview 'e+/ folder for an* 6oring files reuired Unlock full access with a free trial. folder.tds.rece/tion folder.tds.arc%ie (ece/tion folder for 'DS data /rocessing Download With Free Trial rc%ie folder for co+/leted source files data /rocessing folder.tds.re:ect  for (e:ect folder for re:ected source files Sign up to vote on this title /rocessing  Useful  Not useful folder.tds.static older for static files for 'DS /rocessing   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join  Search  Home  Saved 0 38 views Sign In Upload Join RELATED TITLES 0 Insurance Client S2 DE082 ETL Technical Specification v14.doc  Uploaded by Neeharika Uppalapati  Top Charts  Books  Audiobooks  Magazines Insurance Client S2 DE082 ETL Technical Specification v14.doc     Save Embed Share Print 1 Download  News  Documents of 62 Applying So�ware   Solvency II   ETL Testing ETL Test-Case Template  Search document  213560877.doc Sheet Music !/ File Sy5tem Str4ct4re '%is is t%e structure of t%e file s*ste+ used for +anaging t%e data files in SIL and 'DS. ote DS 6ill /rocess data fro+ data,ase ta,le to data,ase ta,le and so does not reuire use of 'rea older !a"e ully =ualified at+ #ro:ect (oot older "TenU"data"SII<(01" In,ound data SO(CE 1 SIL (ece/tion "TenU"data"SII<(01"in,ound 1 SO(CE 2 SIL (ece/tion "TenU"data"SII<(01"in,ound 2 S# SIL (ece/tion "TenU"data"SII<(01"in,ou SIL rc%ie "TenU"data"SII<(01"in,ound SIL (e:ected iles "TenU"data"SII<(01"in,ound SIL (e:ected Source "TenU"data"SII<(01"in,ound 'DS (ece/tion "TenU"data"SII<(01"in,ound You're Reading a Preview Unlock full access with a free trial. 'DS rc%ie 'DS (e:ected iles Download With Free Trial "TenU"data"SII<(01"in,ound Out,ound data "TenU"data"SII<(01"in,ou  Sign up to vote on this title SIL Data Out/ut older  Useful "TenU"data"SII<(01"out,oun  Not useful Static data SIL Static Data "TenU"data"SII<(01"static   Home  Saved  Top Charts  Books  Audiobooks  Magazines  News  Documents  Sheet Music  Upload Sign In Join

Insurance Client S2 DE082 ETL Technical Specification v14.doc

Recommend Documents