dtp settings.pptx
TRANSCRIPT
-
8/18/2019 DTP Settings.pptx
1/35
- Topic :
-Presented By:
1
Standard DTP
-
8/18/2019 DTP Settings.pptx
2/35
2
DTP
DTP – Data Transfer Process
We have 4 types of DTP’s:
Standard DTP Error DTP
Direct Access DTP RDA [Real Time Data Ac!isition" DTP
-
8/18/2019 DTP Settings.pptx
3/35
3
Standard DTP
To e#tract data fromSo!rce $%&ect and loadto Tar'et $%&ect(
)e* in +, -(#
Target Objects
-
8/18/2019 DTP Settings.pptx
4/35
4
Standard DTP
Source Objects
-
8/18/2019 DTP Settings.pptx
5/35
5
Standard DTP
DTP can %e created %y follo*in' *ays:
.
/
0
-
8/18/2019 DTP Settings.pptx
6/35
6
Standard DTP
Properties of Standard DTP
E#traction – So!rce $%&ect relevant properties 1pdate – Tar'et $%&ect relevant properties E#ec!te – Properties relevant for E#ec!tion
-
8/18/2019 DTP Settings.pptx
7/35
7
Standard DTP
E#traction [TA+"
-
8/18/2019 DTP Settings.pptx
8/35
8
Standard DTP
Data So!rce
-
8/18/2019 DTP Settings.pptx
9/35
-
8/18/2019 DTP Settings.pptx
10/35
10
Standard DTP
E#traction 2odes:
31
,t e#tracts all the data from So!rce o%&ect and loads it toTar'et $%&ect *ith respective 53,TER6 selections(
-
8/18/2019 DTP Settings.pptx
11/35
11
Standard DTP
E#traction 2odes:
31
Re!est Records Data2art Stat!s
RE718./09999999 .
RE718./49999999 /
RE718./;9999999 0
RE718./
-
8/18/2019 DTP Settings.pptx
12/35
12
Standard DTP
E#traction 2odes:
DETA
,t only e#tracts ne* data from so!rce o%&ect to Tar'et $%&ect%ased on the Re!est )!m%er =Data 2art Stat!s>(
When *e delete the re!est in the data tar'et it resets theData 2art stat!s of the re!est in so!rce o%&ect and it !illbe processed in the ne#t delta load
-
8/18/2019 DTP Settings.pptx
13/35
13
Standard DTP
E#traction 2odes:
DETA
Re!est Records Data2art Stat!s
RE718./09999999 .
RE718./49999999 /
RE718./;9999999 0
RE718./
-
8/18/2019 DTP Settings.pptx
14/35
14
Standard DTP
E#traction 2odes:
DETA $nly @et Delta $nce
,t only e#tracts ne* data from so!rce o%&ect to Tar'et $%&ect%ased on the Re!est )!m%er =Data 2art Stat!s>(
When *e delete the re!est in the data tar'et it resets theData 2art stat!s of the re!est in so!rce o%&ect %!t it *illNOT %e processed in the ne#t delta load
-
8/18/2019 DTP Settings.pptx
15/35
15
Standard DTP
E#traction 2odes:
DETA $nly @et Delta $nce
Re!est Records Data2art Stat!s
RE718./09999999 .
RE718./49999999 /
RE718./;9999999 0
RE718./
-
8/18/2019 DTP Settings.pptx
16/35
16
Standard DTP
E#traction 2odes:
DETA@et All )e* Data Re!est +y Re!est ,t only e#tracts ne* data from so!rce o%&ect to Tar'et $%&ect
%ased on the Re!est )!m%er =Data 2art Stat!s> %!tprocesses the data Re!est %y Re!est
When *e delete the re!est in the data tar'et it resets theData 2art stat!s of the re!est in so!rce o%&ect %!t it *ill %eprocessed in the ne#t delta load
d d
-
8/18/2019 DTP Settings.pptx
17/35
17
Standard DTP
E#traction 2odes:
DETA@et All )e* DataRe!est +y Re!est
Re!est Records Data2art Stat!s
RE718./09999999 .
RE718./49999999 /
RE718./;9999999 0
RE718./
-
8/18/2019 DTP Settings.pptx
18/35
St d d DTP
-
8/18/2019 DTP Settings.pptx
19/35
19
Standard DTP
PacBa'e Sie
To control n!m%errecords per DataPacBet
Defa!lt : ;
-
8/18/2019 DTP Settings.pptx
20/35
St d d DTP
-
8/18/2019 DTP Settings.pptx
21/35
21
Standard DTP
3ilter
Dynamic Selectionsare possi%le %y !sin'
$AP aria%les
St d d DTP
-
8/18/2019 DTP Settings.pptx
22/35
22
3ilter
Dynamic Selectionsare possi%le %y !sin'
Ro!tine
Standard DTP
-
8/18/2019 DTP Settings.pptx
23/35
Standa d DTP
-
8/18/2019 DTP Settings.pptx
24/35
24
Standard DTP
Semantic @ro!ps
To determinePrimary Bey for%''O' Stack
T(is propert"!ill (a)eimportance !illloading datainto standardDSO because of
o)er!riting *serialization
Standard DTP
-
8/18/2019 DTP Settings.pptx
25/35
25
Standard DTP
1pdate Ta%
Standard DTP
-
8/18/2019 DTP Settings.pptx
26/35
26
Standard DTP
Data Tar'et $%&ect
Standard DTP
-
8/18/2019 DTP Settings.pptx
27/35
27
Standard DTP
Error Candlin'
,n 0(# *e had thisproperty in,nfopacBa'e %!tin +, -(# *e have
this property inDTP
Standard DTP
-
8/18/2019 DTP Settings.pptx
28/35
28
Deacti)ated1sin' this option error stacB is not ena%led at all( Cence for any failed records no data is*ritten to the error stacB( Th!s if the data load fails all the data needs to %e reloaded a'ain(
No update+ no reporting
,f there is erroneo!s Gincorrect record and *e have this option ena%led in the DTP the loadstops there *ith no data *ritten to the error stacB( Also this re!est *ill not %e availa%le forreportin'( Horrection *o!ld mean reloadin' the entire data a'ain(
,alid 'ecords Update+ No reporting -'e.uest 'ed/1sin' this option all correct data is loaded to the c!%es and incorrect data to the error stacB(The data *ill not %e availa%le for reportin' !ntil the erroneo!s records are !pdated and 72stat!s is man!ally set to 'reen( The erroneo!s records can %e !pdated !sin' the error DTP(
,alid 'ecords Updated+ 'eporting $ossible -'e.uest #reen/1sin' this option all correct data is loaded to the c!%es and incorrect data to the error stacB(The data *ill %e availa%le for reportin' and process chains contin!e *ith the ne#t steps( Theerroneo!s records can %e !pdated !sin' the error DTP(
Error Candlin'
Standard DTP
Standard DTP
-
8/18/2019 DTP Settings.pptx
29/35
29
We *ill have this option
*hile loadin' transactiondata to datatar'ets(
We !se option to allo*the transaction data to %eloaded *ith 2aster data
or not
Standard DTP
)e *i++ option on+y in t,eDTP-s *,ic, are +oadin"
data into %aster dataO!ects.
)e use t,is option to,and+e dup+icate records*,i+e +oadin" $aster data
Standard DTP
-
8/18/2019 DTP Settings.pptx
30/35
30
Standard DTP
E#ec!te TA+
Standard DTP
-
8/18/2019 DTP Settings.pptx
31/35
31
Standard DTP
Processin' 2ode
Standard DTP
-
8/18/2019 DTP Settings.pptx
32/35
32
Temporary Data Storage Options in DTP:/n DTP it can set in case to store t,e data te$porari+y in data +oadin"process o# any process +ie e#ore etraction e#ore trans#or$ations. /t*i++ ,e+p in data ana+yin" #or #ai+ed data reuests.
Standard DTP
Standard DTP
-
8/18/2019 DTP Settings.pptx
33/35
33
Temporary store settings :
Standard DTP
Standard DTP
-
8/18/2019 DTP Settings.pptx
34/35
34
Standard DTP
Points to %e )oted
We have to !se process chains to sched!le the Standard DTP in%acB'ro!nd
We can find name of the ta%le for Error stacB
Standard DTP
-
8/18/2019 DTP Settings.pptx
35/35
35
Standard DTP
Settin's for Error StacB