0% found this document useful (0 votes)
81 views9 pages

$Jjuhjdwru7Udqvirupdwlrq: I I I I I I I I I

This chapter describes the aggregator transformation, which performs aggregate calculations like averages and sums. It discusses the components of the aggregator transformation including the aggregate cache, aggregate expressions, group by port, and sorted input. It also covers how to configure the aggregator transformation properties.

Uploaded by

shannu017
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
81 views9 pages

$Jjuhjdwru7Udqvirupdwlrq: I I I I I I I I I

This chapter describes the aggregator transformation, which performs aggregate calculations like averages and sums. It discusses the components of the aggregator transformation including the aggregate cache, aggregate expressions, group by port, and sorted input. It also covers how to configure the aggregator transformation properties.

Uploaded by

shannu017
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 9

&+$37(5

$JJUHJDWRU7UDQVIRUPDWLRQ
7KLVFKDSWHULQFOXGHVWKHIROORZLQJWRSLFV

i $JJUHJDWRU7UDQVIRUPDWLRQ2YHUYLHZ

i &RPSRQHQWVRIWKH$JJUHJDWRU7UDQVIRUPDWLRQ

i &RQILJXULQJ$JJUHJDWH&DFKHV

i $JJUHJDWH([SUHVVLRQV

i *URXS%\3RUWV
i 8VLQJ6RUWHG,QSXW

i &UHDWLQJDQ$JJUHJDWRU7UDQVIRUPDWLRQ

i 7LSVIRU$JJUHJDWRU7UDQVIRUPDWLRQV

i 7URXEOHVKRRWLQJ$JJUHJDWRU7UDQVIRUPDWLRQV

$JJUHJDWRU7UDQVIRUPDWLRQ2YHUYLHZ
7UDQVIRUPDWLRQW\SH
$FWLYH
&RQQHFWHG

7KH$JJUHJDWRUWUDQVIRUPDWLRQSHUIRUPVDJJUHJDWHFDOFXODWLRQVVXFKDVDYHUDJHVDQGVXPV7KH,QWHJUDWLRQ
6HUYLFHSHUIRUPVDJJUHJDWHFDOFXODWLRQVDVLWUHDGVDQGVWRUHVGDWDJURXSDQGURZGDWDLQDQDJJUHJDWHFDFKH
7KH$JJUHJDWRUWUDQVIRUPDWLRQLVXQOLNHWKH([SUHVVLRQWUDQVIRUPDWLRQLQWKDW\RXXVHWKH$JJUHJDWRU
WUDQVIRUPDWLRQWRSHUIRUPFDOFXODWLRQVRQJURXSV7KH([SUHVVLRQWUDQVIRUPDWLRQSHUPLWV\RXWRSHUIRUP
FDOFXODWLRQVRQDURZE\URZEDVLV

:KHQ\RXXVHWKHWUDQVIRUPDWLRQODQJXDJHWRFUHDWHDJJUHJDWHH[SUHVVLRQV\RXFDQXVHFRQGLWLRQDOFODXVHVWR
ILOWHUURZVSURYLGLQJPRUHIOH[LELOLW\WKDQ64/ODQJXDJH

$IWHU\RXFUHDWHDVHVVLRQWKDWLQFOXGHVDQ$JJUHJDWRUWUDQVIRUPDWLRQ\RXFDQHQDEOHWKHVHVVLRQRSWLRQ
,QFUHPHQWDO$JJUHJDWLRQ:KHQWKH,QWHJUDWLRQ6HUYLFHSHUIRUPVLQFUHPHQWDODJJUHJDWLRQLWSDVVHVVRXUFHGDWD
WKURXJKWKHPDSSLQJDQGXVHVKLVWRULFDOFDFKHGDWDWRSHUIRUPDJJUHJDWLRQFDOFXODWLRQVLQFUHPHQWDOO\


&RPSRQHQWVRIWKH$JJUHJDWRU7UDQVIRUPDWLRQ
7KH$JJUHJDWRULVDQDFWLYHWUDQVIRUPDWLRQWKDWFKDQJHVWKHQXPEHURIURZVLQWKHSLSHOLQH7KH$JJUHJDWRU
WUDQVIRUPDWLRQKDVWKHIROORZLQJFRPSRQHQWVDQGRSWLRQV

i $JJUHJDWHFDFKH7KH,QWHJUDWLRQ6HUYLFHVWRUHVGDWDLQWKHDJJUHJDWHFDFKHXQWLOLWFRPSOHWHVDJJUHJDWH
FDOFXODWLRQV7KH,QWHJUDWLRQ6HUYLFHVWRUHVJURXSYDOXHVLQDQLQGH[FDFKHDQGLWVWRUHVURZGDWDLQWKHGDWD
FDFKH
i $JJUHJDWHH[SUHVVLRQ(QWHUDQH[SUHVVLRQLQDQRXWSXWSRUW7KHH[SUHVVLRQFDQLQFOXGHQRQDJJUHJDWH
H[SUHVVLRQVDQGFRQGLWLRQDOFODXVHV
i *URXSE\SRUW,QGLFDWHKRZWRFUHDWHJURXSV<RXFDQFRQILJXUHDQLQSXWLQSXWRXWSXWRXWSXWRUYDULDEOHSRUW
IRUWKHJURXS:KHQJURXSLQJGDWDWKH$JJUHJDWRUWUDQVIRUPDWLRQRXWSXWVWKHODVWURZRIHDFKJURXSXQOHVV
RWKHUZLVHVSHFLILHG
i 6RUWHGLQSXW6HOHFWWKLVRSWLRQWRLPSURYHVHVVLRQSHUIRUPDQFH7RXVHVRUWHGLQSXW\RXPXVWSDVVGDWDWR
WKH$JJUHJDWRUWUDQVIRUPDWLRQVRUWHGE\JURXSE\SRUWLQDVFHQGLQJRUGHVFHQGLQJRUGHU
<RXFDQFRQILJXUHWKH$JJUHJDWRUWUDQVIRUPDWLRQFRPSRQHQWVDQGRSWLRQVRQWKH3URSHUWLHVDQG3RUWVWDE

&RQILJXULQJ$JJUHJDWRU7UDQVIRUPDWLRQ3URSHUWLHV
0RGLI\WKH$JJUHJDWRU7UDQVIRUPDWLRQSURSHUWLHVRQWKH3URSHUWLHVWDE

&RQILJXUHWKHIROORZLQJRSWLRQV

$JJUHJDWRU6HWWLQJ 'HVFULSWLRQ

&DFKH'LUHFWRU\ /RFDOGLUHFWRU\ZKHUHWKH,QWHJUDWLRQ6HUYLFHFUHDWHVWKHLQGH[DQGGDWDFDFKHILOHV%\GHIDXOW
WKH,QWHJUDWLRQ6HUYLFHXVHVWKHGLUHFWRU\HQWHUHGLQWKH:RUNIORZ0DQDJHUIRUWKHSURFHVV
YDULDEOH30&DFKH'LU,I\RXHQWHUDQHZGLUHFWRU\PDNHVXUHWKHGLUHFWRU\H[LVWVDQGFRQWDLQV
HQRXJKGLVNVSDFHIRUWKHDJJUHJDWHFDFKHV
,I\RXKDYHHQDEOHGLQFUHPHQWDODJJUHJDWLRQWKH,QWHJUDWLRQ6HUYLFHFUHDWHVDEDFNXSRIWKHILOHV
HDFKWLPH\RXUXQWKHVHVVLRQ7KHFDFKHGLUHFWRU\PXVWFRQWDLQHQRXJKGLVNVSDFHIRUWZRVHWV
RIWKHILOHV

7UDFLQJ/HYHO $PRXQWRIGHWDLOGLVSOD\HGLQWKHVHVVLRQORJIRUWKLVWUDQVIRUPDWLRQ

6RUWHG,QSXW ,QGLFDWHVLQSXWGDWDLVSUHVRUWHGE\JURXSV6HOHFWWKLVRSWLRQRQO\LIWKHPDSSLQJSDVVHVVRUWHG
GDWDWRWKH$JJUHJDWRUWUDQVIRUPDWLRQ

$JJUHJDWRU'DWD&DFKH 'DWDFDFKHVL]HIRUWKHWUDQVIRUPDWLRQ'HIDXOWFDFKHVL]HLVE\WHV,IWKHWRWDO
6L]H FRQILJXUHGVHVVLRQFDFKHVL]HLV*% E\WHV RUJUHDWHU\RXPXVWUXQWKHVHVVLRQ
RQDELW,QWHJUDWLRQ6HUYLFH<RXFDQFRQILJXUHWKH,QWHJUDWLRQ6HUYLFHWRGHWHUPLQHWKHFDFKH
VL]HDWUXQWLPHRU\RXFDQFRQILJXUHDQXPHULFYDOXH,I\RXFRQILJXUHWKH,QWHJUDWLRQ6HUYLFHWR
GHWHUPLQHWKHFDFKHVL]H\RXFDQDOVRFRQILJXUHDPD[LPXPDPRXQWRIPHPRU\IRUWKH
,QWHJUDWLRQ6HUYLFHWRDOORFDWHWRWKHFDFKH

&RPSRQHQWVRIWKH$JJUHJDWRU7UDQVIRUPDWLRQ
$JJUHJDWRU6HWWLQJ 'HVFULSWLRQ

$JJUHJDWRU,QGH[&DFKH ,QGH[FDFKHVL]HIRUWKHWUDQVIRUPDWLRQ'HIDXOWFDFKHVL]HLVE\WHV,IWKHWRWDO
6L]H FRQILJXUHGVHVVLRQFDFKHVL]HLV*% E\WHV RUJUHDWHU\RXPXVWUXQWKHVHVVLRQ
RQDELW,QWHJUDWLRQ6HUYLFH<RXFDQFRQILJXUHWKH,QWHJUDWLRQ6HUYLFHWRGHWHUPLQHWKHFDFKH
VL]HDWUXQWLPHRU\RXFDQFRQILJXUHDQXPHULFYDOXH,I\RXFRQILJXUHWKH,QWHJUDWLRQ6HUYLFHWR
GHWHUPLQHWKHFDFKHVL]H\RXFDQDOVRFRQILJXUHDPD[LPXPDPRXQWRIPHPRU\IRUWKH
,QWHJUDWLRQ6HUYLFHWRDOORFDWHWRWKHFDFKH

7UDQVIRUPDWLRQ6FRSH 6SHFLILHVKRZWKH,QWHJUDWLRQ6HUYLFHDSSOLHVWKHWUDQVIRUPDWLRQORJLFWRLQFRPLQJGDWD
 7UDQVDFWLRQ$SSOLHVWKHWUDQVIRUPDWLRQORJLFWRDOOURZVLQDWUDQVDFWLRQ&KRRVH7UDQVDFWLRQ
ZKHQDURZRIGDWDGHSHQGVRQDOOURZVLQWKHVDPHWUDQVDFWLRQEXWGRHVQRWGHSHQGRQURZV
LQRWKHUWUDQVDFWLRQV
 $OO,QSXW$SSOLHVWKHWUDQVIRUPDWLRQORJLFRQDOOLQFRPLQJGDWD:KHQ\RXFKRRVH$OO,QSXWWKH
3RZHU&HQWHUGURSVLQFRPLQJWUDQVDFWLRQERXQGDULHV&KRRVH$OO,QSXWZKHQDURZRIGDWD
GHSHQGVRQDOOURZVLQWKHVRXUFH

&RQILJXULQJ$JJUHJDWRU7UDQVIRUPDWLRQ3RUWV
7RFRQILJXUHSRUWVLQWKH$JJUHJDWRUWUDQVIRUPDWLRQFRPSOHWHWKHIROORZLQJWDVNV

i (QWHUDQH[SUHVVLRQLQDQ\RXWSXWSRUWXVLQJFRQGLWLRQDOFODXVHVRUQRQDJJUHJDWHIXQFWLRQVLQWKHSRUW
i &UHDWHPXOWLSOHDJJUHJDWHRXWSXWSRUWV

i &RQILJXUHDQ\LQSXWLQSXWRXWSXWRXWSXWRUYDULDEOHSRUWDVDJURXSE\SRUW

i ,PSURYHSHUIRUPDQFHE\FRQQHFWLQJRQO\WKHQHFHVVDU\LQSXWRXWSXWSRUWVWRVXEVHTXHQWWUDQVIRUPDWLRQV
UHGXFLQJWKHVL]HRIWKHGDWDFDFKH
i 8VHYDULDEOHSRUWVIRUORFDOYDULDEOHV

i &UHDWHFRQQHFWLRQVWRRWKHUWUDQVIRUPDWLRQVDV\RXHQWHUDQH[SUHVVLRQ

&RQILJXULQJ$JJUHJDWH&DFKHV
:KHQ\RXUXQDVHVVLRQWKDWXVHVDQ$JJUHJDWRUWUDQVIRUPDWLRQWKH,QWHJUDWLRQ6HUYLFHFUHDWHVWKHLQGH[DQGWKH
GDWDFDFKHVLQPHPRU\WRSURFHVVWKHWUDQVIRUPDWLRQ,IWKH,QWHJUDWLRQ6HUYLFHUHTXLUHVPRUHVSDFHLWVWRUHV
RYHUIORZYDOXHVLQFDFKHILOHV

<RXFDQFRQILJXUHWKHLQGH[DQGWKHGDWDFDFKHVLQWKH$JJUHJDWRUWUDQVIRUPDWLRQRULQWKHVHVVLRQSURSHUWLHV2U
\RXFDQFRQILJXUHWKH,QWHJUDWLRQ6HUYLFHWRGHWHUPLQHWKHFDFKHVL]HDWUXQWLPH

1RWH7KH,QWHJUDWLRQ6HUYLFHXVHVPHPRU\WRSURFHVVDQ$JJUHJDWRUWUDQVIRUPDWLRQZLWKVRUWHGSRUWV7KH
,QWHJUDWLRQ6HUYLFHGRHVQRWXVHFDFKHPHPRU\<RXGRQRWQHHGWRFRQILJXUHFDFKHPHPRU\IRU$JJUHJDWRU
WUDQVIRUPDWLRQVWKDWXVHVRUWHGSRUWV

&KDSWHU$JJUHJDWRU7UDQVIRUPDWLRQ
$JJUHJDWH([SUHVVLRQV
7KH'HVLJQHUDOORZVDJJUHJDWHH[SUHVVLRQVRQO\LQWKH$JJUHJDWRUWUDQVIRUPDWLRQ$QDJJUHJDWHH[SUHVVLRQFDQ
LQFOXGHFRQGLWLRQDOFODXVHVDQGQRQDJJUHJDWHIXQFWLRQV7KHH[SUHVVLRQFDQDOVRLQFOXGHRQHDJJUHJDWHIXQFWLRQ
ZLWKLQDQRWKHUDJJUHJDWHIXQFWLRQVXFKDV
0$; &2817 ,7(0

7KHUHVXOWRIDQDJJUHJDWHH[SUHVVLRQYDULHVEDVHGRQWKHJURXSE\SRUWVLQWKHWUDQVIRUPDWLRQ)RUH[DPSOH
ZKHQWKH,QWHJUDWLRQ6HUYLFHFDOFXODWHVWKHIROORZLQJDJJUHJDWHH[SUHVVLRQZLWKQRJURXSE\SRUWVGHILQHGLWILQGV
WKHWRWDOTXDQWLW\RILWHPVVROG
680 48$17,7<

+RZHYHULI\RXXVHWKHVDPHH[SUHVVLRQDQG\RXJURXSE\WKH,7(0SRUWWKH,QWHJUDWLRQ6HUYLFHUHWXUQVWKH
WRWDOTXDQWLW\RILWHPVVROGE\LWHP

<RXFDQFUHDWHDQDJJUHJDWHH[SUHVVLRQLQDQ\RXWSXWSRUWDQGXVHPXOWLSOHDJJUHJDWHSRUWVLQDWUDQVIRUPDWLRQ

5(/$7('723,&6
i ³:RUNLQJZLWK([SUHVVLRQV´RQSDJH

$JJUHJDWH)XQFWLRQV
8VHWKHIROORZLQJDJJUHJDWHIXQFWLRQVZLWKLQDQ$JJUHJDWRUWUDQVIRUPDWLRQ<RXFDQQHVWRQHDJJUHJDWHIXQFWLRQ
ZLWKLQDQRWKHUDJJUHJDWHIXQFWLRQ

7KHWUDQVIRUPDWLRQODQJXDJHLQFOXGHVWKHIROORZLQJDJJUHJDWHIXQFWLRQV

i $9*
i &2817

i ),567

i /$67

i 0$;
i 0(',$1

i 0,1

i 3(5&(17,/(

i 67''(9

i 680

i 9$5,$1&(

:KHQ\RXXVHDQ\RIWKHVHIXQFWLRQV\RXPXVWXVHWKHPLQDQH[SUHVVLRQZLWKLQDQ$JJUHJDWRUWUDQVIRUPDWLRQ

1HVWHG$JJUHJDWH)XQFWLRQV
<RXFDQLQFOXGHPXOWLSOHVLQJOHOHYHORUPXOWLSOHQHVWHGIXQFWLRQVLQGLIIHUHQWRXWSXWSRUWVLQDQ$JJUHJDWRU
WUDQVIRUPDWLRQ+RZHYHU\RXFDQQRWLQFOXGHERWKVLQJOHOHYHODQGQHVWHGIXQFWLRQVLQDQ$JJUHJDWRU
WUDQVIRUPDWLRQ7KHUHIRUHLIDQ$JJUHJDWRUWUDQVIRUPDWLRQFRQWDLQVDVLQJOHOHYHOIXQFWLRQLQDQ\RXWSXWSRUW\RX
FDQQRWXVHDQHVWHGIXQFWLRQLQDQ\RWKHUSRUWLQWKDWWUDQVIRUPDWLRQ:KHQ\RXLQFOXGHVLQJOHOHYHODQGQHVWHG
IXQFWLRQVLQWKHVDPH$JJUHJDWRUWUDQVIRUPDWLRQWKH'HVLJQHUPDUNVWKHPDSSLQJRUPDSSOHWLQYDOLG,I\RXQHHG
WRFUHDWHERWKVLQJOHOHYHODQGQHVWHGIXQFWLRQVFUHDWHVHSDUDWH$JJUHJDWRUWUDQVIRUPDWLRQV

$JJUHJDWH([SUHVVLRQV
&RQGLWLRQDO&ODXVHV
8VHFRQGLWLRQDOFODXVHVLQWKHDJJUHJDWHH[SUHVVLRQWRUHGXFHWKHQXPEHURIURZVXVHGLQWKHDJJUHJDWLRQ7KH
FRQGLWLRQDOFODXVHFDQEHDQ\FODXVHWKDWHYDOXDWHVWR758(RU)$/6(

)RUH[DPSOHXVHWKHIROORZLQJH[SUHVVLRQWRFDOFXODWHWKHWRWDOFRPPLVVLRQVRIHPSOR\HHVZKRH[FHHGHGWKHLU
TXDUWHUO\TXRWD
680 &200,66,21&200,66,21!4827$

1RQ$JJUHJDWH)XQFWLRQV
<RXFDQDOVRXVHQRQDJJUHJDWHIXQFWLRQVLQWKHDJJUHJDWHH[SUHVVLRQ

7KHIROORZLQJH[SUHVVLRQUHWXUQVWKHKLJKHVWQXPEHURILWHPVVROGIRUHDFKLWHP JURXSHGE\LWHP ,IQRLWHPV


ZHUHVROGWKHH[SUHVVLRQUHWXUQV
,,) 0$; 48$17,7< !0$; 48$17,7< 

1XOO9DOXHVLQ$JJUHJDWH)XQFWLRQV
:KHQ\RXFRQILJXUHWKH,QWHJUDWLRQ6HUYLFH\RXFDQFKRRVHKRZ\RXZDQWWKH,QWHJUDWLRQ6HUYLFHWRKDQGOHQXOO
YDOXHVLQDJJUHJDWHIXQFWLRQV<RXFDQFKRRVHWRWUHDWQXOOYDOXHVLQDJJUHJDWHIXQFWLRQVDV18//RU]HUR%\
GHIDXOWWKH,QWHJUDWLRQ6HUYLFHWUHDWVQXOOYDOXHVDV18//LQDJJUHJDWHIXQFWLRQV

*URXS%\3RUWV
7KH$JJUHJDWRUWUDQVIRUPDWLRQOHWV\RXGHILQHJURXSVIRUDJJUHJDWLRQVUDWKHUWKDQSHUIRUPLQJWKHDJJUHJDWLRQ
DFURVVDOOLQSXWGDWD)RUH[DPSOHUDWKHUWKDQILQGLQJWKHWRWDOFRPSDQ\VDOHV\RXFDQILQGWKHWRWDOVDOHV
JURXSHGE\UHJLRQ

7RGHILQHDJURXSIRUWKHDJJUHJDWHH[SUHVVLRQVHOHFWWKHDSSURSULDWHLQSXWLQSXWRXWSXWRXWSXWDQGYDULDEOH
SRUWVLQWKH$JJUHJDWRUWUDQVIRUPDWLRQ<RXFDQVHOHFWPXOWLSOHJURXSE\SRUWVWRFUHDWHDQHZJURXSIRUHDFK
XQLTXHFRPELQDWLRQ7KH,QWHJUDWLRQ6HUYLFHWKHQSHUIRUPVWKHGHILQHGDJJUHJDWLRQIRUHDFKJURXS

:KHQ\RXJURXSYDOXHVWKH,QWHJUDWLRQ6HUYLFHSURGXFHVRQHURZIRUHDFKJURXS,I\RXGRQRWJURXSYDOXHVWKH
,QWHJUDWLRQ6HUYLFHUHWXUQVRQHURZIRUDOOLQSXWURZV7KH,QWHJUDWLRQ6HUYLFHW\SLFDOO\UHWXUQVWKHODVWURZRIHDFK
JURXS RUWKHODVWURZUHFHLYHG ZLWKWKHUHVXOWRIWKHDJJUHJDWLRQ+RZHYHULI\RXVSHFLI\DSDUWLFXODUURZWREH
UHWXUQHG IRUH[DPSOHE\XVLQJWKH),567IXQFWLRQ WKH,QWHJUDWLRQ6HUYLFHWKHQUHWXUQVWKHVSHFLILHGURZ

:KHQVHOHFWLQJPXOWLSOHJURXSE\SRUWVLQWKH$JJUHJDWRUWUDQVIRUPDWLRQWKH,QWHJUDWLRQ6HUYLFHXVHVSRUWRUGHUWR
GHWHUPLQHWKHRUGHUE\ZKLFKLWJURXSV6LQFHJURXSRUGHUFDQDIIHFWWKHUHVXOWVRUGHUJURXSE\SRUWVWRHQVXUH
WKHDSSURSULDWHJURXSLQJ)RUH[DPSOHWKHUHVXOWVRIJURXSLQJE\,7(0B,'WKHQ48$17,7<FDQYDU\IURP
JURXSLQJE\48$17,7<WKHQ,7(0B,'EHFDXVHWKHQXPHULFYDOXHVIRUTXDQWLW\DUHQRWQHFHVVDULO\XQLTXH

7KHIROORZLQJ$JJUHJDWRUWUDQVIRUPDWLRQJURXSVILUVWE\6725(B,'DQGWKHQE\,7(0

&KDSWHU$JJUHJDWRU7UDQVIRUPDWLRQ
,I\RXVHQGWKHIROORZLQJGDWDWKURXJKWKLV$JJUHJDWRUWUDQVIRUPDWLRQ
6725(B,' ,7(0 47< 35,&(

EDWWHU\
 

EDWWHU\
 

EDWWHU\
 

$$$
 

EDWWHU\
 

EDWWHU\
 

EDWWHU\
 

7KH,QWHJUDWLRQ6HUYLFHSHUIRUPVWKHDJJUHJDWHFDOFXODWLRQRQWKHIROORZLQJXQLTXHJURXSV
6725(B,' ,7(0

EDWWHU\


$$$


EDWWHU\


EDWWHU\

7KH,QWHJUDWLRQ6HUYLFHWKHQSDVVHVWKHODVWURZUHFHLYHGDORQJZLWKWKHUHVXOWVRIWKHDJJUHJDWLRQDVIROORZV
6725(B,' ,7(0 47< 35,&( 6$/(6B3(5B6725(

EDWWHU\
  

$$$
  

EDWWHU\
  

EDWWHU\
  

1RQ$JJUHJDWH([SUHVVLRQV
8VHQRQDJJUHJDWHH[SUHVVLRQVLQJURXSE\SRUWVWRPRGLI\RUUHSODFHJURXSV)RUH[DPSOHLI\RXZDQWWRUHSODFH
µ$$$EDWWHU\¶EHIRUHJURXSLQJ\RXFDQFUHDWHDQHZJURXSE\RXWSXWSRUWQDPHG&255(&7('B,7(0XVLQJWKH
IROORZLQJH[SUHVVLRQ
,,) ,7(0 
$$$EDWWHU\
EDWWHU\,7(0

'HIDXOW9DOXHV
'HILQHDGHIDXOWYDOXHIRUHDFKSRUWLQWKHJURXSWRUHSODFHQXOOLQSXWYDOXHV7KLVDOORZVWKH,QWHJUDWLRQ6HUYLFHWR
LQFOXGHQXOOLWHPJURXSVLQWKHDJJUHJDWLRQ

5(/$7('723,&6
i ³8VLQJ'HIDXOW9DOXHVIRU3RUWV´RQSDJH

8VLQJ6RUWHG,QSXW
<RXFDQLPSURYH$JJUHJDWRUWUDQVIRUPDWLRQSHUIRUPDQFHE\XVLQJWKHVRUWHGLQSXWRSWLRQ:KHQ\RXXVHVRUWHG
LQSXWWKH,QWHJUDWLRQ6HUYLFHDVVXPHVDOOGDWDLVVRUWHGE\JURXSDQGLWSHUIRUPVDJJUHJDWHFDOFXODWLRQVDVLW
UHDGVURZVIRUDJURXS:KHQQHFHVVDU\LWVWRUHVJURXSLQIRUPDWLRQLQPHPRU\7RXVHWKH6RUWHG,QSXWRSWLRQ
\RXPXVWSDVVVRUWHGGDWDWRWKH$JJUHJDWRUWUDQVIRUPDWLRQ<RXFDQJDLQSHUIRUPDQFHZLWKVRUWHGSRUWVZKHQ
\RXFRQILJXUHWKHVHVVLRQZLWKPXOWLSOHSDUWLWLRQV

:KHQ\RXGRQRWXVHVRUWHGLQSXWWKH,QWHJUDWLRQ6HUYLFHSHUIRUPVDJJUHJDWHFDOFXODWLRQVDVLWUHDGV6LQFHWKH
GDWDLVQRWVRUWHGWKH,QWHJUDWLRQ6HUYLFHVWRUHVGDWDIRUHDFKJURXSXQWLOLWUHDGVWKHHQWLUHVRXUFHWRHQVXUHDOO
DJJUHJDWHFDOFXODWLRQVDUHDFFXUDWH

8VLQJ6RUWHG,QSXW
)RUH[DPSOHRQH$JJUHJDWRUWUDQVIRUPDWLRQKDVWKH6725(B,'DQG,7(0JURXSE\SRUWVZLWKWKHVRUWHGLQSXW
RSWLRQVHOHFWHG:KHQ\RXSDVVWKHIROORZLQJGDWDWKURXJKWKH$JJUHJDWRUWKH,QWHJUDWLRQ6HUYLFHSHUIRUPVDQ
DJJUHJDWLRQIRUWKHWKUHHURZVLQWKHEDWWHU\JURXSDVVRRQDVLWILQGVWKHQHZJURXSEDWWHU\
6725(B,' ,7(0 47< 35,&(

EDWWHU\
 

EDWWHU\
 

EDWWHU\
 

EDWWHU\
 

EDWWHU\
 

,I\RXXVHVRUWHGLQSXWDQGGRQRWSUHVRUWGDWDFRUUHFWO\\RXUHFHLYHXQH[SHFWHGUHVXOWV

6RUWHG,QSXW&RQGLWLRQV
'RQRWXVHVRUWHGLQSXWLIHLWKHURIWKHIROORZLQJFRQGLWLRQVDUHWUXH

i 7KHDJJUHJDWHH[SUHVVLRQXVHVQHVWHGDJJUHJDWHIXQFWLRQV

i 7KHVHVVLRQXVHVLQFUHPHQWDODJJUHJDWLRQ

,I\RXXVHVRUWHGLQSXWDQGGRQRWVRUWGDWDFRUUHFWO\WKHVHVVLRQIDLOV

6RUWLQJ'DWD
7RXVHVRUWHGLQSXW\RXSDVVVRUWHGGDWDWKURXJKWKH$JJUHJDWRU

'DWDPXVWEHVRUWHGLQWKHIROORZLQJZD\V

i %\WKH$JJUHJDWRUJURXSE\SRUWVLQWKHRUGHUWKH\DSSHDULQWKH$JJUHJDWRUWUDQVIRUPDWLRQ

i 8VLQJWKHVDPHVRUWRUGHUFRQILJXUHGIRUWKHVHVVLRQ,IGDWDLVQRWLQVWULFWDVFHQGLQJRUGHVFHQGLQJRUGHU
EDVHGRQWKHVHVVLRQVRUWRUGHUWKH,QWHJUDWLRQ6HUYLFHIDLOVWKHVHVVLRQ)RUH[DPSOHLI\RXFRQILJXUHD
VHVVLRQWRXVHD)UHQFKVRUWRUGHUGDWDSDVVLQJLQWRWKH$JJUHJDWRUWUDQVIRUPDWLRQPXVWEHVRUWHGXVLQJWKH
)UHQFKVRUWRUGHU
)RUUHODWLRQDODQGILOHVRXUFHVXVHWKH6RUWHUWUDQVIRUPDWLRQWRVRUWGDWDLQWKHPDSSLQJEHIRUHSDVVLQJLWWRWKH
$JJUHJDWRUWUDQVIRUPDWLRQ<RXFDQSODFHWKH6RUWHUWUDQVIRUPDWLRQDQ\ZKHUHLQWKHPDSSLQJSULRUWRWKH
$JJUHJDWRULIQRWUDQVIRUPDWLRQFKDQJHVWKHRUGHURIWKHVRUWHGGDWD*URXSE\FROXPQVLQWKH$JJUHJDWRU
WUDQVIRUPDWLRQPXVWEHLQWKHVDPHRUGHUDVWKH\DSSHDULQWKH6RUWHUWUDQVIRUPDWLRQ

,IWKHVHVVLRQXVHVUHODWLRQDOVRXUFHV\RXFDQDOVRXVHWKH1XPEHURI6RUWHG3RUWVRSWLRQLQWKH6RXUFH4XDOLILHU
WUDQVIRUPDWLRQWRVRUWJURXSE\FROXPQVLQWKHVRXUFHGDWDEDVH*URXSE\FROXPQVPXVWEHLQWKHVDPHRUGHULQ
ERWKWKH$JJUHJDWRUDQG6RXUFH4XDOLILHUWUDQVIRUPDWLRQV

7KHIROORZLQJPDSSLQJVKRZVD6RUWHUWUDQVIRUPDWLRQFRQILJXUHGWRVRUWWKHVRXUFHGDWDLQDVFHQGLQJRUGHUE\
,7(0B12

7KH6RUWHUWUDQVIRUPDWLRQVRUWVWKHGDWDDVIROORZV
,7(0B12 ,7(0B1$0( 47< 35,&(
 6RXS  
 6RXS  
 6RXS  
 &HUHDO  
 &HUDO  

&KDSWHU$JJUHJDWRU7UDQVIRUPDWLRQ
:LWKVRUWHGLQSXWWKH$JJUHJDWRUWUDQVIRUPDWLRQUHWXUQVWKHIROORZLQJUHVXOWV
,7(0B1$0( 47< 35,&( ,1&20(B3(5B,7(0
&HUHDO   
6RXS   

&UHDWLQJDQ$JJUHJDWRU7UDQVIRUPDWLRQ
7RXVHDQ$JJUHJDWRUWUDQVIRUPDWLRQLQDPDSSLQJDGGWKH$JJUHJDWRUWUDQVIRUPDWLRQWRWKHPDSSLQJ7KHQ
FRQILJXUHWKHWUDQVIRUPDWLRQZLWKDQDJJUHJDWHH[SUHVVLRQDQGJURXSE\SRUWV

7RFUHDWHDQ$JJUHJDWRUWUDQVIRUPDWLRQ

 ,QWKH0DSSLQJ'HVLJQHUFOLFN7UDQVIRUPDWLRQ!&UHDWH6HOHFWWKH$JJUHJDWRUWUDQVIRUPDWLRQ
 (QWHUDQDPHIRUWKH$JJUHJDWRUFOLFN&UHDWH7KHQFOLFN'RQH
7KH'HVLJQHUFUHDWHVWKH$JJUHJDWRUWUDQVIRUPDWLRQ
 'UDJWKHSRUWVWRWKH$JJUHJDWRUWUDQVIRUPDWLRQ
7KH'HVLJQHUFUHDWHVLQSXWRXWSXWSRUWVIRUHDFKSRUW\RXLQFOXGH
 'RXEOHFOLFNWKHWLWOHEDURIWKHWUDQVIRUPDWLRQWRRSHQWKH(GLW7UDQVIRUPDWLRQVGLDORJER[
 6HOHFWWKH3RUWVWDE
 &OLFNWKHJURXSE\RSWLRQIRUHDFKFROXPQ\RXZDQWWKH$JJUHJDWRUWRXVHLQFUHDWLQJJURXSV
2SWLRQDOO\HQWHUDGHIDXOWYDOXHWRUHSODFHQXOOJURXSV
 &OLFN$GGWRDGGDQH[SUHVVLRQSRUW
7KHH[SUHVVLRQSRUWPXVWEHDQRXWSXWSRUW0DNHWKHSRUWDQRXWSXWSRUWE\FOHDULQJ,QSXW , 
 2SWLRQDOO\DGGGHIDXOWYDOXHVIRUVSHFLILFSRUWV
,IWKHWDUJHWGDWDEDVHGRHVQRWKDQGOHQXOOYDOXHVDQGFHUWDLQSRUWVDUHOLNHO\WRFRQWDLQQXOOYDOXHVVSHFLI\D
GHIDXOWYDOXH
 &RQILJXUHSURSHUWLHVRQWKH3URSHUWLHVWDE

7LSVIRU$JJUHJDWRU7UDQVIRUPDWLRQV
8VHVRUWHGLQSXWWRGHFUHDVHWKHXVHRIDJJUHJDWHFDFKHV
6RUWHGLQSXWUHGXFHVWKHDPRXQWRIGDWDFDFKHGGXULQJWKHVHVVLRQDQGLPSURYHVVHVVLRQSHUIRUPDQFH8VHWKLV
RSWLRQZLWKWKH6RUWHUWUDQVIRUPDWLRQWRSDVVVRUWHGGDWDWRWKH$JJUHJDWRUWUDQVIRUPDWLRQ

/LPLWFRQQHFWHGLQSXWRXWSXWRURXWSXWSRUWV
/LPLWWKHQXPEHURIFRQQHFWHGLQSXWRXWSXWRURXWSXWSRUWVWRUHGXFHWKHDPRXQWRIGDWDWKH$JJUHJDWRU
WUDQVIRUPDWLRQVWRUHVLQWKHGDWDFDFKH

)LOWHUWKHGDWDEHIRUHDJJUHJDWLQJLW
,I\RXXVHD)LOWHUWUDQVIRUPDWLRQLQWKHPDSSLQJSODFHWKHWUDQVIRUPDWLRQEHIRUHWKH$JJUHJDWRUWUDQVIRUPDWLRQWR
UHGXFHXQQHFHVVDU\DJJUHJDWLRQ

&UHDWLQJDQ$JJUHJDWRU7UDQVIRUPDWLRQ
7URXEOHVKRRWLQJ$JJUHJDWRU7UDQVIRUPDWLRQV
,VHOHFWHGVRUWHGLQSXWEXWWKHZRUNIORZWDNHVWKHVDPHDPRXQWRIWLPHDVEHIRUH
<RXFDQQRWXVHVRUWHGLQSXWLIDQ\RIWKHIROORZLQJFRQGLWLRQVDUHWUXH

i 7KHDJJUHJDWHH[SUHVVLRQFRQWDLQVQHVWHGDJJUHJDWHIXQFWLRQV

i 7KHVHVVLRQXVHVLQFUHPHQWDODJJUHJDWLRQ

i 6RXUFHGDWDLVGDWDGULYHQ

:KHQDQ\RIWKHVHFRQGLWLRQVDUHWUXHWKH,QWHJUDWLRQ6HUYLFHSURFHVVHVWKHWUDQVIRUPDWLRQDVLI\RXGRQRWXVH
VRUWHGLQSXW

$VHVVLRQXVLQJDQ$JJUHJDWRUWUDQVIRUPDWLRQFDXVHVVORZSHUIRUPDQFH
7KH,QWHJUDWLRQ6HUYLFHPD\EHSDJLQJWRGLVNGXULQJWKHZRUNIORZ<RXFDQLQFUHDVHVHVVLRQSHUIRUPDQFHE\
LQFUHDVLQJWKHLQGH[DQGGDWDFDFKHVL]HVLQWKHWUDQVIRUPDWLRQSURSHUWLHV

,HQWHUHGDQRYHUULGHFDFKHGLUHFWRU\LQWKH$JJUHJDWRUWUDQVIRUPDWLRQEXWWKH,QWHJUDWLRQ6HUYLFHVDYHVWKH
VHVVLRQLQFUHPHQWDODJJUHJDWLRQILOHVVRPHZKHUHHOVH
<RXFDQRYHUULGHWKHWUDQVIRUPDWLRQFDFKHGLUHFWRU\RQDVHVVLRQOHYHO7KH,QWHJUDWLRQ6HUYLFHQRWHVWKHFDFKH
GLUHFWRU\LQWKHVHVVLRQORJ<RXFDQDOVRFKHFNWKHVHVVLRQSURSHUWLHVIRUDQRYHUULGHFDFKHGLUHFWRU\

&KDSWHU$JJUHJDWRU7UDQVIRUPDWLRQ

You might also like