7/17/2019 PowerCenter Level1 Unit08

1/7

1

Unit 8. Sequence Generator

Unit 8

7/17/2019 PowerCenter Level1 Unit08

2/7

2

Unit Objectives

Understand when and how to use the SequenceGenerator transformation

Use it in a mapping

Unit 8

7/17/2019 PowerCenter Level1 Unit08

3/7

3

Sequence GeneratorTransformation

Generates unique keys for any port on a row

Passive

Ports Two predefined output ports,

NEXTV! and "U##V! No input ports

Usage Generate sequenced $e%s

e&g& unique primar% $e%s Sharea'(e across mappings

Unit 8

7/17/2019 PowerCenter Level1 Unit08

4/7

Sequence Generator !cont"#$

%&enever a row is written to t&e '(pression transformation)

*'+T,- is written to t&e tar/et

*'+T,- is set to t&e va0ue of U,-

U,- is increase# by t&e ncrement 4y va0ue set in properties

Use U,- on0y if you nee# a secon# sequence# output !on0y increases w&en *'+T,- use#$

f you connect *'+T,- to two transformations5 it /enerates unique sequence number b0ocks!first one5 t&en t&e ot&er$

Unit 8

7/17/2019 PowerCenter Level1 Unit08

5/7

6

Unit 8 aboa# 7ate 7imension Tab0e

reate a mappin/ usin/)S&ortcuts for source an# tar/etSequence Generator transformation

reaterun a workf0ow for t&is mappin/

Staging

rea

)ata

*arehouse

STG97-T'S!tab0e$ 7:97-T'S!tab0e$

Unit 8

7/17/2019 PowerCenter Level1 Unit08

6/7

;

ab eview

*hat did we accomp(ish with this (a'+

uestions+

Unit 8

7/17/2019 PowerCenter Level1 Unit08

7/7

-& *hen wou(d %ou use the Sequence Generatortransformation+

.& *hat is the re(ationship 'etween "U##V! and

NEXTV!+

Unit 8