tag:blogger.com,1999:blog-69321669920775472982024-03-19T23:44:57.909-07:00Core Synesis (BI Tips - Dicas BI)www.coresynesis.com.br
A CORE SYNESIS traz para o mercado produtos e serviços integrados de apoio à gestão empresarial. Nossas soluções unem conceitos de gestão, conhecimento de funções empresariais, tecnologias da informação e conhecimento do negócio.
Levamos ao mercado o conceito de Process and Performance Management. O suporte tecnológico das soluções da Core Synesis é resultado da aplicação combinada de tecnologias de apoio a gestão, abrangendo BI, BA, BPM e CM.Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.comBlogger35125tag:blogger.com,1999:blog-6932166992077547298.post-18185768167541059942017-06-23T07:02:00.001-07:002017-06-23T07:02:20.058-07:00PowerBI (EXTRA) - Análise de Mídias Sociais<div style="text-align: center;">
<span style="font-size: large;">Análise de Mídias Sociais</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/2p_ejr-aaqo/0.jpg" src="https://www.youtube.com/embed/2p_ejr-aaqo?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-59322929054268428622017-06-23T06:56:00.000-07:002017-06-23T06:56:56.979-07:00Treinamento Power BI - Vídeo 15 de 15<div style="text-align: center;">
<span style="font-size: large;">Importar Visualizações</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/ZDcNPHVedSY/0.jpg" src="https://www.youtube.com/embed/ZDcNPHVedSY?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-14911627521270574392017-06-23T06:52:00.000-07:002017-06-23T06:52:54.541-07:00Treinamento Power BI - Vídeo 14 de 15<div style="text-align: center;">
<span style="font-size: large;">Dimensão Tempo</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/IeKDjAdhpDg/0.jpg" src="https://www.youtube.com/embed/IeKDjAdhpDg?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-77565798661331403792017-06-23T06:46:00.001-07:002017-06-23T06:46:25.600-07:00Treinamento Power BI - Vídeo 13 de 15<div style="text-align: center;">
<span style="font-size: large;">Parâmetros</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/B8paCBM72Yg/0.jpg" src="https://www.youtube.com/embed/B8paCBM72Yg?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<br />
<br />Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-60572221894393920362017-06-14T09:53:00.000-07:002017-06-14T09:53:35.555-07:00Treinamento Power BI - Vídeo 12 de 15<div style="text-align: center;">
<span style="font-size: large;">Filtros de Relatório e Página</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/xepC1ouighI/0.jpg" src="https://www.youtube.com/embed/xepC1ouighI?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-65649767525708095492017-06-14T09:50:00.003-07:002017-06-14T09:50:51.368-07:00Treinamento Power BI - Vídeo 11 de 15<div style="text-align: center;">
<b><span style="font-size: large;">Mapa e Substituição de Valores</span></b></div>
<div style="text-align: center;">
<b><span style="font-size: large;"><br /></span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/umQvPglU0rg/0.jpg" src="https://www.youtube.com/embed/umQvPglU0rg?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="text-align: center;">
<b><span style="font-size: large;"><br /></span></b></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-57619856319612370522017-06-14T09:49:00.000-07:002017-06-14T09:49:47.264-07:00Treinamento Power BI - Vídeo 10 de 15<div style="text-align: center;">
<b><span style="font-size: large;">Filtro em Consultas</span></b></div>
<div style="text-align: center;">
<b><span style="font-size: large;"><br /></span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/gIGzH_bg8ZE/0.jpg" src="https://www.youtube.com/embed/gIGzH_bg8ZE?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="text-align: center;">
<b><span style="font-size: large;"><br /></span></b></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-24847630113596732582017-06-06T12:19:00.001-07:002017-06-06T12:19:20.773-07:00Treinamento Power BI - Vídeo 9 de 15<div style="text-align: center;">
<span style="font-size: large;">Alterar Tipos de Gráfico</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/PuIFJ0NfGgM/0.jpg" src="https://www.youtube.com/embed/PuIFJ0NfGgM?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-55824053806104060532017-06-06T12:17:00.000-07:002017-06-06T12:18:26.419-07:00Treinamento Power BI - Vídeo 8 de 15<div style="text-align: center;">
<span style="font-size: large;">Hierarquias & Drill Down</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/9IF-rZityvc/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/9IF-rZityvc?feature=player_embedded" width="320"></iframe></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-33418466341401806962017-06-06T12:11:00.004-07:002017-06-06T12:11:41.238-07:00Treinamento Power BI - Vídeo 7 de 15<div style="text-align: center;">
<span style="font-size: large;">Crosstab & Campos Calculados</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/1qdSTHY747k/0.jpg" src="https://www.youtube.com/embed/1qdSTHY747k?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-33628041682753531022017-05-28T10:47:00.000-07:002017-05-28T10:47:44.758-07:00Treinamento Power BI - Vídeo 6 de 15<div style="text-align: center;">
<span style="font-size: large;">Listas</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/i9lttHO2qy4/0.jpg" src="https://www.youtube.com/embed/i9lttHO2qy4?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-15402400111875088172017-05-28T10:41:00.001-07:002017-05-28T10:41:02.347-07:00Treinamento Power BI - Vídeo 5 de 15<div style="text-align: center;">
<span style="font-size: large;">Gráfico Gauge</span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/Ki4-6Ioc9hI/0.jpg" src="https://www.youtube.com/embed/Ki4-6Ioc9hI?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<br />Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-75565083255036557352017-05-28T10:35:00.001-07:002017-05-28T10:35:04.652-07:00Treinamento Power BI - Vídeo 4 de 15<div style="text-align: center;">
<span style="font-size: large;">Relacionamento</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/Nwc3plbgE3g/0.jpg" src="https://www.youtube.com/embed/Nwc3plbgE3g?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-83059457192406437182017-05-25T08:24:00.001-07:002017-05-25T08:24:39.551-07:00Treinamento Power BI - Vídeo 3 de 15<div style="text-align: center;">
<span style="font-size: large;">Manipulação e Join</span></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/u6unoCJum2A/0.jpg" src="https://www.youtube.com/embed/u6unoCJum2A?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div>
<br /></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-20939335649127207102017-05-25T07:32:00.002-07:002017-05-25T07:32:22.726-07:00Treinamento Power BI - Vídeo 2 de 15<div style="text-align: center;">
<span style="font-size: large;">Manipulação básica - Power BI</span></div>
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/Hukzp8OJGgM/0.jpg" src="https://www.youtube.com/embed/Hukzp8OJGgM?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<br />Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-89577378691129562842017-05-25T06:32:00.002-07:002017-05-25T08:25:32.616-07:00Treinamento Power BI - Vídeo 1 de 15<div style="text-align: center;">
<span style="font-size: large;">Neste primeiro vídeo veremos como </span></div>
<div style="text-align: center;">
<span style="font-size: large;">fazer a Importação de Dados</span><br />
<span style="font-size: large;"><br /></span>
<span style="font-size: large;"><a href="https://youtu.be/bLC-1Dwx7os">Power BI - Importação de dados</a></span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/bLC-1Dwx7os/0.jpg" src="https://www.youtube.com/embed/bLC-1Dwx7os?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<br /></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<br /></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-17430600263739021682016-07-18T06:51:00.002-07:002016-07-18T07:10:37.228-07:00Carga da Dimensão Tempo (Com Feriados Brasil) - PLSQL/*<br />
Autor: Erick Furst<br />
Empresa: Core Synesis<br />
Data: 20/08/2015<br />
Descrição: Processo para carga da Dimensão Tempo.<br />
--------------------------------------------------<br />
<br />
--Carga dimensão Ano (Year dimension load)<br />
declare<br />
Data DATE;<br />
DataIni DATE;<br />
DataFim DATE;<br />
Data_Movel DATE;<br />
BEGIN<br />
DataIni := to_date('2000/01/01','yyyy/mm/dd');<br />
DataFim := to_date('2040/12/31','yyyy/mm/dd');<br />
Data := DataIni;<br />
WHILE Data <= DataFim LOOP<br />
INSERT INTO DIM_ANO ( NUM_ANO, NUM_ANO_ANT )<br />
VALUES ( TO_CHAR(extract(YEAR from Data)), TO_CHAR(extract(YEAR from Data)-1) );<br />
Data := add_months(Data,12);<br />
Data := add_months(Data,1) - extract(DAY from (add_months(Data,1)));<br />
END LOOP;<br />
COMMIT;<br />
END;<br />
-- select * from ano<br />
--------------------------------------------------<br />
<br />
--Carga dimensão Semestre (Six month period dimension load)<br />
declare<br />
Data DATE;<br />
DataIni DATE;<br />
DataFim DATE;<br />
Data_Movel DATE;<br />
<br />
BEGIN<br />
DataIni := to_date('2000/01/01','yyyy/mm/dd');<br />
DataFim := to_date('2040/12/31','yyyy/mm/dd');<br />
Data := DataIni;<br />
WHILE Data <= DataFim LOOP<br />
INSERT INTO DIM_SEMESTRE(NUM_ANO_SMT, DES_ANO_SMT, NUM_SMT, DES_SMT, NUM_ANO )<br />
VALUES<br />
(<br />
TO_CHAR(extract(YEAR from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'01'<br />
,2,'01'<br />
,3,'02'<br />
,4,'02'),<br />
DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'1º Semestre de '<br />
,2,'1º Semestre de '<br />
,3,'2º Semestre de '<br />
,4,'2º Semestre de ') || TO_CHAR(extract(YEAR from Data)),<br />
DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'01'<br />
,2,'01'<br />
,3,'02'<br />
,4,'02'),<br />
DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'1º Semestre'<br />
,2,'1º Semestre'<br />
,3,'2º Semestre'<br />
,4,'2º Semestre'),<br />
TO_CHAR(extract(YEAR from Data))<br />
);<br />
Data := add_months(Data,6);<br />
Data := add_months(Data,1) - extract(DAY from (add_months(Data,1)));<br />
<br />
END LOOP;<br />
COMMIT;<br />
END;<br />
-- select * from semestre<br />
--------------------------------------------------<br />
<br />
--Carga dimensão trimestre (Quarter dimension load)<br />
<br />
declare<br />
Data DATE;<br />
DataIni DATE;<br />
DataFim DATE;<br />
Data_Movel DATE;<br />
BEGIN<br />
DataIni := to_date('2000/01/01','yyyy/mm/dd');<br />
DataFim := to_date('2040/12/31','yyyy/mm/dd');<br />
Data := DataIni;<br />
WHILE Data <= DataFim LOOP<br />
INSERT INTO DIM_TRIMESTRE(NUM_ANO_TRM, DES_ANO_TRM, NUM_TRM, DES_TRM, NUM_ANO_SMT)<br />
VALUES<br />
(<br />
TO_CHAR(extract(YEAR from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'01'<br />
,2,'02'<br />
,3,'03'<br />
,4,'04'),<br />
<br />
DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'1º Trimestre de '<br />
,2,'2º Trimestre de '<br />
,3,'3º Trimestre de '<br />
,4,'4º Trimestre de ') || TO_CHAR(extract(YEAR from Data)),<br />
<br />
DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'01'<br />
,2,'02'<br />
,3,'03'<br />
,4,'04'),<br />
<br />
<br />
DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'1º Trimestre'<br />
,2,'2º Trimestre'<br />
,3,'3º Trimestre'<br />
,4,'4º Trimestre'), <br />
<br />
TO_CHAR(extract(YEAR from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'01'<br />
,2,'01'<br />
,3,'02'<br />
,4,'02')<br />
);<br />
Data := add_months(Data,3);<br />
Data := add_months(Data,1) - extract(DAY from (add_months(Data,1)));<br />
END LOOP;<br />
COMMIT;<br />
END;<br />
-- select * from trimestre<br />
--------------------------------------------------<br />
<br />
--Carga dimensão mês (month dimension load)<br />
declare<br />
Data DATE;<br />
DataIni DATE;<br />
DataFim DATE;<br />
Data_Movel DATE;<br />
BEGIN<br />
DataIni := to_date('2000/01/01','yyyy/mm/dd');<br />
DataFim := to_date('2040/12/31','yyyy/mm/dd');<br />
Data := DataIni;<br />
WHILE Data <= DataFim LOOP<br />
INSERT INTO DIM_MES (NUM_ANO_MES, DES_ANO_MES, NUM_MES, DES_MES, DES_MES_ABV, NUM_ANO_TRM,<br />
NUM_ANO_ANT_MES, NUM_ANO_MES_ANT, NUM_ANO_MES_INI_MDL_VLR)<br />
VALUES<br />
(<br />
TO_CHAR(extract(YEAR from Data)) || TO_CHAR(Data, 'MM'),<br />
<br />
(CASE extract(MONTH from Data)<br />
WHEN (1) THEN ('Janeiro')<br />
WHEN (2) THEN ('Fevereiro')<br />
WHEN (3) THEN ('Março')<br />
WHEN (4) THEN ('Abril')<br />
WHEN (5) THEN ('Maio')<br />
WHEN (6) THEN ('Junho')<br />
WHEN (7) THEN ('Julho')<br />
WHEN (8) THEN ('Agosto')<br />
WHEN (9) THEN ('Setembro')<br />
WHEN (10) THEN ('Outubro')<br />
WHEN (11) THEN ('Novembro')<br />
WHEN (12) THEN ('Dezembro')<br />
END) || ' de ' || TO_CHAR(extract(YEAR from Data)),<br />
<br />
TO_CHAR(Data, 'MM'),<br />
<br />
(CASE extract(MONTH from Data)<br />
WHEN (1) THEN ('Janeiro')<br />
WHEN (2) THEN ('Fevereiro')<br />
WHEN (3) THEN ('Março')<br />
WHEN (4) THEN ('Abril')<br />
WHEN (5) THEN ('Maio')<br />
WHEN (6) THEN ('Junho')<br />
WHEN (7) THEN ('Julho')<br />
WHEN (8) THEN ('Agosto')<br />
WHEN (9) THEN ('Setembro')<br />
WHEN (10) THEN ('Outubro')<br />
WHEN (11) THEN ('Novembro')<br />
WHEN (12) THEN ('Dezembro')<br />
END), <br />
<br />
(CASE extract(MONTH from Data)<br />
WHEN (1) THEN ('Jan')<br />
WHEN (2) THEN ('Fev')<br />
WHEN (3) THEN ('Mar')<br />
WHEN (4) THEN ('Abr')<br />
WHEN (5) THEN ('Mai')<br />
WHEN (6) THEN ('Jun')<br />
WHEN (7) THEN ('Jul')<br />
WHEN (8) THEN ('Ago')<br />
WHEN (9) THEN ('Set')<br />
WHEN (10) THEN ('Out')<br />
WHEN (11) THEN ('Nov')<br />
WHEN (12) THEN ('Dez')<br />
END), <br />
<br />
<br />
TO_CHAR(extract(YEAR from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'01'<br />
,2,'02'<br />
,3,'03'<br />
,4,'04'),<br />
<br />
TO_NUMBER(TO_CHAR(extract(YEAR from Data)) || TO_CHAR(Data, 'MM'))-100,<br />
<br />
CASE WHEN extract(MONTH from Data) <> 1<br />
THEN TO_NUMBER(TO_CHAR(extract(YEAR from Data)) || TO_CHAR(Data, 'MM'))-1<br />
ELSE TO_NUMBER(TO_CHAR(extract(YEAR from Data)) || TO_CHAR(Data, 'MM'))-89<br />
END,<br />
<br />
TO_NUMBER(TO_CHAR(extract(YEAR from ADD_MONTHS(Data,-3))) || TO_CHAR(ADD_MONTHS(Data,-3), 'MM'))<br />
<br />
);<br />
<br />
Data := add_months(Data,1);<br />
Data := add_months(Data,1) - extract(DAY from (add_months(Data,1)));<br />
END LOOP;<br />
COMMIT;<br />
END;<br />
-- SELECT * FROM MES ORDER BY 1<br />
--------------------------------------------------<br />
<br />
--Carga dimensão Data (Day dimension load)<br />
declare<br />
Data DATE;<br />
DataIni DATE;<br />
DataFim DATE;<br />
Data_Movel DATE;<br />
VarA INT;<br />
VarB INT;<br />
VarC INT;<br />
VarD INT;<br />
VarE INT;<br />
VarF INT;<br />
VarG INT;<br />
VarH INT;<br />
VarI INT;<br />
VarAno INT;<br />
MesPascoa INT;<br />
DiaPascoa INT;<br />
DataPascoaNum INT;<br />
DataPascoa DATE;<br />
DataCarnaval DATE;<br />
DataQuartaCinzas DATE;<br />
DataSextaSanta DATE;<br />
DataCorpusChristi DATE;<br />
<br />
BEGIN<br />
<br />
DataIni := to_date('2000/01/01','yyyy/mm/dd');<br />
DataFim := to_date('2040/12/31','yyyy/mm/dd'); <br />
<br />
Data := DataIni;<br />
data_movel := DataFim;<br />
<br />
WHILE Data <= DataFim LOOP<br />
<br />
--Código para cálculo de feriado móvel. <br />
VarAno := extract(YEAR from Data);<br />
VarA := TRUNC(VarAno/100);<br />
VarB := VarAno-(19*TRUNC(VarAno/19));<br />
VarC := TRUNC((VarA-17)/25);<br />
VarD := VarA-TRUNC(VarA/4)-TRUNC((VarA-VarC)/3)+19*VarB+15;<br />
VarE := VarD-30*TRUNC(VarD/30);<br />
VarF := VarE-(TRUNC(VarE/28)*(1-TRUNC(VarE/28))*TRUNC(29/(VarE+1))*TRUNC(21-VarB/11));<br />
VarG := VarAno+TRUNC(VarAno/4)+VarF+2-VarA+TRUNC(VarA/4);<br />
VarH := VarG-(7*TRUNC(VarG/7));<br />
VarI := VarF-VarH;<br />
MesPascoa := 3+TRUNC((VarI+40)/44);<br />
DiaPascoa := VarI+28-31*TRUNC(MesPascoa/4);<br />
<br />
DataPascoaNum := (VarAno * 100 + MesPascoa) * 100 + DiaPascoa;<br />
DataPascoa := TO_DATE(DataPascoaNum, 'yyyymmdd');<br />
DataCarnaval := DataPascoa - 47;<br />
DataQuartaCinzas := DataCarnaval + 1;<br />
DataSextaSanta := DataPascoa - 2;<br />
DataCorpusChristi := DataPascoa + 60;<br />
<br />
<br />
INSERT INTO DIM_DATA ( DAT_DIA, NUM_ANO_MES, NUM_DIA_SEM, DES_DIA_SEM, DES_DIA_SEM_ABV, IND_DIA_UTL, IND_FRD, DES_FRD,<br />
DAT_DIA_ANT, DAT_PRI_DIA_MES, DAT_ULT_DIA_MES, DAT_INI_MDL_VLR, NUM_ANO,<br />
NUM_ANO_SMT, NUM_ANO_TRM, DAT_ANO_ANT, DAT_ULT_DIA_MES_ANT )<br />
VALUES<br />
(<br />
TO_DATE(Data,'DD/MM/YY'),<br />
TO_NUMBER(TO_CHAR(extract(YEAR from Data)) || TO_CHAR(Data, 'MM')),<br />
TO_NUMBER( TO_CHAR (Data, 'D') ),<br />
CASE TO_NUMBER( TO_CHAR (Data, 'D') )<br />
WHEN 1 THEN 'Domingo'<br />
WHEN 2 THEN 'Segunda-feira'<br />
WHEN 3 THEN 'Terça-feira'<br />
WHEN 4 THEN 'Quarta-feira'<br />
WHEN 5 THEN 'Quinta-feira'<br />
WHEN 6 THEN 'Sexta-feira'<br />
WHEN 7 THEN 'Sábado' <br />
END,<br />
CASE TO_NUMBER( TO_CHAR (Data, 'D') )<br />
WHEN 1 THEN 'Dom'<br />
WHEN 2 THEN 'Seg'<br />
WHEN 3 THEN 'Ter'<br />
WHEN 4 THEN 'Qua'<br />
WHEN 5 THEN 'Qui'<br />
WHEN 6 THEN 'Sex'<br />
WHEN 7 THEN 'Sáb' <br />
END,<br />
<br />
CASE WHEN EXTRACT(MONTH from Data) * 100 + EXTRACT(DAY from Data)<br />
IN (101, 421, 501, 907, 1012, 1102, 1115, 1225, 125, 709, 1120,<br />
-- EXTRACT(MONTH from DataCarnaval) * 100 + EXTRACT(DAY from DataCarnaval),<br />
-- EXTRACT(MONTH from DataQuartaCinzas) * 100 + EXTRACT(DAY from DataQuartaCinzas),<br />
EXTRACT(MONTH from DataSextaSanta) * 100 + EXTRACT(DAY from DataSextaSanta),<br />
EXTRACT(MONTH from DataCorpusChristi) * 100 + EXTRACT(DAY from DataCorpusChristi) )<br />
OR ( TO_NUMBER( TO_CHAR (Data, 'D') ) IN (1,7) )<br />
THEN 'N'<br />
ELSE 'S'<br />
END,<br />
CASE WHEN EXTRACT(MONTH from Data) * 100 + EXTRACT(DAY from Data)<br />
IN (101, 421, 501, 907, 1012, 1102, 1115, 1225, 125, 709, 1120,<br />
-- EXTRACT(MONTH from DataCarnaval) * 100 + EXTRACT(DAY from DataCarnaval),<br />
-- EXTRACT(MONTH from DataQuartaCinzas) * 100 + EXTRACT(DAY from DataQuartaCinzas),<br />
EXTRACT(MONTH from DataSextaSanta) * 100 + EXTRACT(DAY from DataSextaSanta),<br />
EXTRACT(MONTH from DataCorpusChristi) * 100 + EXTRACT(DAY from DataCorpusChristi) )<br />
THEN 'S'<br />
ELSE 'N'<br />
END,<br />
CASE EXTRACT(MONTH from Data) * 100 + EXTRACT(DAY from Data)<br />
WHEN 101 THEN 'Confraternização Universal' --01/01<br />
WHEN 421 THEN 'Tiradentes' -- 21/04<br />
WHEN 501 THEN 'Dia do Trabalho' -- 01/05<br />
WHEN 907 THEN 'Idependência do Brasil' -- 07/09<br />
WHEN 1012 THEN 'Nossa Sra. Aparecida' -- 12/10<br />
WHEN 1102 THEN 'Finados' -- 02/11<br />
WHEN 1115 THEN 'Proclamação da República' -- 15/11<br />
WHEN 1225 THEN 'Natal' -- 25/12<br />
WHEN 125 THEN 'Aniversário de São Paulo' -- 25/01<br />
WHEN 709 THEN 'Revolução Constitucionalista de 1932' -- 09/07<br />
WHEN 1120 THEN 'Consciência Negra' -- 20/11 <br />
WHEN EXTRACT(MONTH from DataPascoa) * 100 + EXTRACT(DAY from DataPascoa) THEN 'Páscoa'<br />
WHEN EXTRACT(MONTH from DataCarnaval) * 100 + EXTRACT(DAY from DataCarnaval) THEN 'Carnaval'<br />
WHEN EXTRACT(MONTH from DataQuartaCinzas) * 100 + EXTRACT(DAY from DataQuartaCinzas) THEN 'Quarta-feira de Cinzas'<br />
WHEN EXTRACT(MONTH from DataSextaSanta) * 100 + EXTRACT(DAY from DataSextaSanta) THEN 'Sexta-feira da Paixão'<br />
WHEN EXTRACT(MONTH from DataCorpusChristi) * 100 + EXTRACT(DAY from DataCorpusChristi) THEN 'Corpus Christi'<br />
ELSE ('NA')<br />
END , <br />
TO_CHAR(Data - 1,'DD/MM/YYYY'),<br />
TO_CHAR((Data - extract(DAY from (Data))) + 1,'DD/MM/YYYY'), <br />
TO_CHAR(ADD_MONTHS(Data,1) - extract(DAY from (Data)),'DD/MM/YYYY') ,<br />
TO_CHAR((ADD_MONTHS(Data,-3) - extract(DAY from (Data))) + 1,'DD/MM/YYYY'),<br />
TO_CHAR(extract(YEAR from Data)),<br />
TO_CHAR(extract(YEAR from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'01'<br />
,2,'01'<br />
,3,'02'<br />
,4,'02'),<br />
TO_CHAR(extract(YEAR from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<br />
,1,'01'<br />
,2,'02'<br />
,3,'03'<br />
,4,'04'),<br />
add_months(Data,-12),<br />
TO_CHAR(Data - extract(DAY from Data),'DD/MM/YYYY')<br />
);<br />
<br />
Data := Data + 1;<br />
END LOOP;<br />
COMMIT;<br />
<br />
END;<br />
<br />
/*<br />
select * from data<br />
WHERE NUM_ANO_MES = 200011<br />
--AND DES_FRD <> 'NA'<br />
order by 1<br />
*/--------------------------------------------------Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-5405879544443045852014-08-07T12:28:00.005-07:002014-08-08T06:04:27.032-07:00Pentaho Data Integration (PDI) - Kettle<b>Pentaho Data Integration (PDI) - Kettle</b><br />
<br />
<br />
<b>Neste Tutorial: - Video 1 (</b>In this Tutorial: - Video 1<b>)</b><br />
Criar Transformação (Create Transformation)<br />
Criar Conexão de BD (Create DB Connection)<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/os5ZfEoloeo?feature=player_embedded' frameborder='0'></iframe></div>
<br />
<br />
<br />
<b>Neste Tutorial: - Video 2 (</b>In this Tutorial: - Video 2 )<br />
Criar Consultas (Create Queries )<br />
Criar Joins (Crate Joins )<br />
Ordenação (Sorting)<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/xFx6bBUhR9c?feature=player_embedded' frameborder='0'></iframe></div>
<br />
<br />
<br />
<b>Neste Tutorial: - Video 3 ( </b>In this Tutorial: - Video 3 )<br />
Concatenação (Concatenation)<br />
Data Sistema (System Date)<br />
LEFT e CASE (LEFT and CASE sintax)<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/XkLMGctpWRQ?feature=player_embedded' frameborder='0'></iframe></div>
<br />
<br />
<b>Neste Tutorial: - Video 4 (</b>In this Tutorial: - Video 4)<br />
Técnicas de validação e retorno de campo (Lookup). -Validation techniques and field return (Lookup). -<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/Nf2cvdV3WUk?feature=player_embedded' frameborder='0'></iframe></div>
<br />
<br />
<br />
<b>Neste Tutorial: - Video 5 (</b>In this Tutorial: - Video 5)<br />
Uso de variáveis (Variables)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<object width="320" height="266" class="BLOGGER-youtube-video" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" data-thumbnail-src="https://i.ytimg.com/vi/0uOoSeBi_Vw/0.jpg"><param name="movie" value="https://www.youtube.com/v/0uOoSeBi_Vw?version=3&f=user_uploads&c=google-webdrive-0&app=youtube_gdata" /><param name="bgcolor" value="#FFFFFF" /><param name="allowFullScreen" value="true" /><embed width="320" height="266" src="https://www.youtube.com/v/0uOoSeBi_Vw?version=3&f=user_uploads&c=google-webdrive-0&app=youtube_gdata" type="application/x-shockwave-flash" allowfullscreen="true"></embed></object></div>
<br />
<br />
<b>Neste Tutorial: - Video 6 (</b>In this Tutorial: - Video 6)<br />
Java Script<br />
Validação e criação de campo indicador (Validation and flag field)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/Tj0OUUnLBDg?feature=player_embedded' frameborder='0'></iframe></div>
<br />
<br />Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-71732642838582102612014-02-20T09:13:00.000-08:002014-02-20T09:13:03.843-08:00<a href="http://www.gusas.com.br/emailmkt_bra/2014/eventos/sasday/minas/sasday-minas.html">SAS Directions MG 2014</a>Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-90492731666123958332013-10-09T11:46:00.001-07:002013-10-09T11:47:02.422-07:00Treinamento ODI 11G (ODI 11G Training) 4/14<b style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><span style="font-size: medium;">Vídeo número 4 (Video # four):</span></b><br />
<br />
<div style="text-align: justify;">
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 14px; line-height: 19px;"><b>Criar Contexto, Arquitetura Física e Lógica e Modelos.</b></span></span></div>
<div style="text-align: justify;">
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 14px; line-height: 19px;"><b>(Create Context, Logical and Physical Architecture and Models)</b></span></span></div>
<div style="text-align: justify;">
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 14px; line-height: 19px;"><b><br /></b></span></span></div>
<div style="text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<object class="BLOGGER-youtube-video" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" data-thumbnail-src="https://ytimg.googleusercontent.com/vi/pxrQbsE_7ZY/0.jpg" height="266" width="320"><param name="movie" value="https://www.youtube.com/v/pxrQbsE_7ZY?version=3&f=user_uploads&c=google-webdrive-0&app=youtube_gdata" /><param name="bgcolor" value="#FFFFFF" /><param name="allowFullScreen" value="true" /><embed width="320" height="266" src="https://www.youtube.com/v/pxrQbsE_7ZY?version=3&f=user_uploads&c=google-webdrive-0&app=youtube_gdata" type="application/x-shockwave-flash" allowfullscreen="true"></embed></object></div>
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 14px; line-height: 19px;"><b><br /></b></span></span></div>
<div style="text-align: justify;">
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 14px; line-height: 19px;"><b><br /></b></span></span></div>
<div style="text-align: justify;">
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 14px; line-height: 19px;"><b>Video Transcript:</b></span></span></div>
<div style="text-align: justify;">
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 14px; line-height: 19px;"><b><br /></b></span></span>
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: xx-small; line-height: 19px;"><u>Português:</u></span></span></div>
<div style="text-align: justify;">
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Click no botão para criar um novo contexto.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o nome do contexto.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: Development</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o código do contexto.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: CONTEXT1</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe a senha.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: oracle1</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Marque o checkbox: Default</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Agora crie a arquitetura física.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Escolha o item "Oracle" e em seguida "Novo Servidor de Dados".</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite o nome da conexão.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Como boa prática para a formação do nome, digite primeiro o SID e em seguidao nome do esquema.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: ORCL_TRNREL</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o SID.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: orcl</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o usuário.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: TrRel</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe a senha.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: Laboratoriosql1</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o driver JDBC.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe a URL.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o nome da conexão.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: ORCL_TRNDIM</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o SID.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: orcl</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o usuário.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: TrDim</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe a senha.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: Laboratoriosql1</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o driver e a URL.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Crie a Arquitetura Lógica.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Escolha a opção "Oracle" e em seguida "Novo Esquema Lógico".</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o nome do esquema lógico.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: ORCL_TRNREL</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Agora crie o esquema lógico para a conexão com o banco de dados de destino.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o nome do esquema lógico.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: ORCL_TRNDIM</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">De volta à Arquitetura física crie um esquema físico para cada conexão com o BD.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Click com o botão direito sobre a conexão e escolha a opção "Novo Esquema Físico".</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Associe a conexão com o esquema físico.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Adicione o contexto.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Associe o esquema físico ao esquema lógico.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Repita o processo para a conexão com o banco de dados de origem.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Agora crie um modelo para cada esquema (Origem e Destino). E importe as tabelas.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite o nome da pasta que irá conter os modelos dos dados de origem.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite o nome da pasta que irá conter os modelos dos dados de destino.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Click com o botão direito do mouse sobre a pasta "Origem" e escolha a opção "Novo Modelo".</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Click vom o botão direito do mouse sobre a pasta "Origem" e escolha a opção "Novo Modelo".</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe o nome do modelo.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Digite: TrnRel</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Informe a Tecnologia.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Escolha: Oracle</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Associe ao esquema lógico.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Escolha: ORCL_TRNREL</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Click no botão [Engenharia Reversa] para retornar as tabelas do banco de origem.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Repita o processo para o banco de dados de destino.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Click com o botão direito do mouse sobre uma tabela e escolha a opção "Dados".</span></span><br />
<span style="color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: xx-small; line-height: 19px;">Fim do vídeo.</span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;"><br /></span></span>
<br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;"><u>English:</u></span></span><br />
<span style="color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: xx-small; line-height: 19px;">Click the button to create a new context .</span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the name of the context .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : Development</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the code context .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : Context1</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the password .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : ORACLE1</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Mark the checkbox : Default</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Now create the physical architecture .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Choose the item " Oracle " and then " New Data Server " .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the connection name .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">As good practice for the training name , first enter the SID and seguidao schema name .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : ORCL_TRNREL</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the SID .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : orcl</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Inform the user .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : TrRel</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the password .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : Laboratoriosql1</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the JDBC driver .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the URL .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the name of the connection.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : ORCL_TRNDIM</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the SID .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : orcl</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Inform the user .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : TrDim</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the password .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : Laboratoriosql1</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Tell the driver and URL .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Create Logical Architecture .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Choose the " Oracle " and then " New Logical Schema " .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the name of the logical schema .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : ORCL_TRNREL</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Now create the logical schema to connect to the target database .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the name of the logical schema .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : ORCL_TRNDIM</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Back to Physical Architecture create a physical schema for each connection to the database .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Right click on the link and choose " New Physical Schema " .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Associate the connection with the physical schema .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Add context.</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Associate the physical schema to the logical schema .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Repeat the process for connecting to the database source .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Now create a template for each schema ( Origin and Destination ) . And import the tables .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the name of the folder that will contain models of the source data .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the name of the folder that will contain the target data models .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Click with the right mouse button on the folder "Source" and choose " New Model " .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Click vom right- click on the folder "Source" and choose " New Model " .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Enter the model name .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Type : TrnRel</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Notify Technology .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Choose : Oracle</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Assign the logical schema .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Choose : ORCL_TRNREL</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Click the button [ Reverse Engineering ] to return the database tables of origin .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Repeat the process for the database target .</span></span><br />
<span style="color: #333333; font-family: Helvetica Neue Light, HelveticaNeue-Light, Helvetica Neue, Helvetica, Arial, sans-serif; font-size: xx-small;"><span style="line-height: 19px;">Click with the right mouse button on a table and choose " Data " .</span></span><br />
<span style="color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: xx-small; line-height: 19px;">End of video.</span></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-90459390695294814792013-10-09T09:13:00.000-07:002013-10-09T09:13:05.129-07:00Treinamento ODI 11G (ODI 11G Training) 3/14<span style="font-size: large;"><br /></span>
<b><span style="font-size: large;">Vídeo número 3 (Video # three):</span></b><br />
<br />
<b>Criar conexão com Repositório de trabalho (Create Work Repository connection)</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/1rHYy6Bgn9k?feature=player_embedded' frameborder='0'></iframe></div>
<br />
<br />
<b>Video Transcript:</b><br />
<br />
<span style="font-size: xx-small;">Click no menu "ODI" e em seguida na opção "Conectar".</span><br />
<span style="font-size: xx-small;">(Click on the menu "ODI" and then on "Connect".)</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Click em [OK]</span><br />
<span style="font-size: xx-small;">Escolha a aba "Repositórios".</span><br />
<span style="font-size: xx-small;">(Choose the tab "Repositories".)</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Click com o botão direito do mouse e escolha a opção "Novo Repositório de Trabalho".</span><br />
<span style="font-size: xx-small;">(Click with the right mouse button and choose "New Work Repository".)</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Altere o usuário para: snpm1</span><br />
<span style="font-size: xx-small;">(Change the user to: snpm1)</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Click no botão [Testar Conexão]</span><br />
<span style="font-size: xx-small;">(Click the [Test Connection])</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Click no botão [Próximo]</span><br />
<span style="font-size: xx-small;">(Click the [Next] button)</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Digite a senha: trabalho</span><br />
<span style="font-size: xx-small;">(Enter password: work)</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Click no botão [Finalizar]</span><br />
<span style="font-size: xx-small;">(Click the [Finish] button)</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Click no botão [Sim].</span><br />
<span style="font-size: xx-small;">(Click the [Yes] button)</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Digite: WORKREP1</span><br />
<span style="font-size: xx-small;">(Type: WORKREP1)</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Click no botão [OK]</span><br />
<span style="font-size: xx-small;">(Click the [OK] button)</span><br />
<span style="font-size: xx-small;"><br /></span>
<span style="font-size: xx-small;">Repositório Criado.</span><br />
<span style="font-size: xx-small;">(Repository created)</span>Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-47647974483672413462013-10-09T07:20:00.003-07:002013-10-09T07:20:27.829-07:00Treinamento ODI 11G (ODI 11G Training) 2/14<br />
<b style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><span style="font-size: medium;">Vídeo número 2 (</span>Video # two<span style="font-size: medium;">):</span></b><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" /><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" /><b>Criar usuário para o Repositório Master</b><b style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"> (Create user for Master Repository)</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/LZ8XgOtUsSo?feature=player_embedded' frameborder='0'></iframe></div>
<br />
<br />
<b>Video Transcript:</b><br />
<br />
<span style="font-size: x-small;">Criar usuário para o Repositório Master</span><br />
<span style="font-size: x-small;">(Create user for the Master Repository)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Click no menu "Arquivo" e em seguida na opção "Novo".</span><br />
<span style="font-size: x-small;">(Click the "File" menu and "New" option.)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Escolha a opção "Criar um Novo Log-in do Repositório ODI"</span><br />
<span style="font-size: x-small;">(Choose "Create a new login ODI Repository")</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Click no botão [OK].</span><br />
<span style="font-size: x-small;">(Click the button [OK].)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Digite o nome do Log-in.</span><br />
<span style="font-size: x-small;">(Enter the name of the login.)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Digite: Master Repository</span><br />
<span style="font-size: x-small;">(Type: Master Repository)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Digite o nome do usuário.</span><br />
<span style="font-size: x-small;">(Enter the user name.)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Digite: SUPERVISOR</span><br />
<span style="font-size: x-small;">(Type: SUPERVISOR)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Informe a senha.</span><br />
<span style="font-size: x-small;">(Enter the password.)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Digite: Laboratoriosql1</span><br />
<span style="font-size: x-small;">(Type: Laboratoriosql1)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Informe os dados para conexão com o banco de dados do repositório.</span><br />
<span style="font-size: x-small;">(Enter the data for connecting to the database repository.)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Digite: snpm1</span><br />
<span style="font-size: x-small;">(Type: snpm1)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Informe a senha:</span><br />
<span style="font-size: x-small;">(Enter the password:)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Digite: oracle1</span><br />
<span style="font-size: x-small;">(Type: ORACLE1)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Em "Lista de Drivers" escolha "Oracle JDBC Driver".</span><br />
<span style="font-size: x-small;">(In "List of Drivers" choice "Oracle JDBC Driver".)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Informe a url de conexão com o BD.</span><br />
<span style="font-size: x-small;">(Enter the url connection to the database.)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Click no botão [Testar].</span><br />
<span style="font-size: x-small;">(Click the [Test] button.)</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Click no botão [OK]</span><br />
<span style="font-size: x-small;">(Click the button [OK])</span><br />
<span style="font-size: x-small;"><br /></span>
<span style="font-size: x-small;">Usuário criado</span><br />
<span style="font-size: x-small;">(User created)</span>Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-49614417914065803962013-10-09T06:41:00.001-07:002013-10-09T06:41:38.048-07:00Treinamento ODI 11G (ODI 11G Training) 1/14Este E-learning é o primeiro vídeo de um conjunto que será publicado demonstrando como aplicar técnicas de carga de um DW através de uma ferramenta de ELT, o Oracle Data Integrator 11G.<br />
<br />
(<span style="font-size: x-small;">This E-learning is the first video of a series to be published demonstrating how to apply load techniques to a DW through an ELT tool, Oracle Data Integrator 11g.</span>)<br />
<br />
<b><span style="font-size: large;">Vídeo número 1 (</span>Video # one<span style="font-size: large;">):</span></b><br />
<br />
<b>Criar o Repositório Mestre (Create Master Repository)</b><br />
<br />
Note que já existe um esquema de BD criado com o nome de snpm1 no Oracle.<br />
(<span style="font-size: x-small;">Note that's already exist a BD scheme created with the name of the Oracle snpm1.</span>)<br />
<br />
Informe a senha que você registrar para este esquema (Não obrigatoriamente a mesma do vídeo).<br />
(<span style="font-size: x-small;">Enter the password that you typed for this scheme (not necessarily the same as that video</span>))<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /><iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/L-mApB4CZFM?feature=player_embedded' frameborder='0'></iframe></div>
<br />Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-9464911971567206642013-09-18T11:47:00.000-07:002013-09-18T11:47:02.628-07:00SAP Business Objects Data Services (por Gláucia Sibele)<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<h1>
<a href="" name="_Toc294692165"><span style="font-family: "Verdana","sans-serif";">SAP
Business Objects Data Services</span></a><span style="font-family: "Verdana","sans-serif";">
</span><span style="font-family: "Script MT Bold"; font-size: 12.0pt;">por Gláucia
Sibele</span><span style="font-family: "Verdana","sans-serif";"><o:p></o:p></span></h1>
<div class="MsoNormal">
<br /></div>
<div align="center" class="MsoListParagraph" style="display: none; margin-bottom: 3.0pt; margin-left: 18.0pt; margin-right: 0cm; margin-top: 10.0pt; mso-list: l3 level1 lfo12; mso-outline-level: 2; text-align: center; text-indent: -18.0pt;">
<a href="" name="_Toc291663308"></a><a href="" name="_Toc291681126"></a><a href="" name="_Toc291681991"></a><a href="" name="_Toc294692166"></a><!--[if !supportLists]--><b><span style="display: none; font-family: "Verdana","sans-serif"; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana; mso-fareast-language: EN-US; mso-hide: all;">1.</span></b><!--[endif]--><b><span style="display: none; font-family: "Verdana","sans-serif"; mso-fareast-language: EN-US; mso-hide: all;"><o:p> </o:p></span></b></div>
<div align="center" class="MsoListParagraph" style="display: none; margin-bottom: 3.0pt; margin-left: 18.0pt; margin-right: 0cm; margin-top: 10.0pt; mso-list: l3 level1 lfo12; mso-outline-level: 2; text-align: center; text-indent: -18.0pt;">
<a href="" name="_Toc291663309"></a><a href="" name="_Toc291681127"></a><a href="" name="_Toc291681992"></a><a href="" name="_Toc294692167"></a><!--[if !supportLists]--><b><span style="display: none; font-family: "Verdana","sans-serif"; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana; mso-fareast-language: EN-US; mso-hide: all;">2.</span></b><!--[endif]--><b><span style="display: none; font-family: "Verdana","sans-serif"; mso-fareast-language: EN-US; mso-hide: all;"><o:p> </o:p></span></b></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">O BO Data Services é um software que
permite planejar, organizar, desenvolver e administrar de forma visual os
processos de ETL.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">Benefícios: <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 54.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l5 level1 lfo1; tab-stops: list 54.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">•<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Facilita o processo de
organização de dados de diferentes fontes através de uma interface gráfica.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 54.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l5 level1 lfo1; tab-stops: list 54.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">•<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Extrai, transforma e carrega
os dados de fontes heterogenias em um único banco de dados usando processos que
organizam os fluxos de carga.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 54.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l5 level1 lfo1; tab-stops: list 54.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">•<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Compartilha objetos em um
ambiente de ETL onde exista mais de um desenvolvedor.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 54.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l5 level1 lfo1; tab-stops: list 54.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">•<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Permite a administração
dos projetos via WEB.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">Arquitetura do Data Services:<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: 36.0pt; text-align: justify;">
<span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">O SAP BO
Data Services contêm diversos componentes para desenvolver e administrar as
rotinas de ETL, sendo eles:<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 90.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l9 level1 lfo2; tab-stops: list 90.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">•<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Designer:<o:p></o:p></span></b></div>
<div class="MsoListParagraphCxSpFirst" style="margin-left: 126.0pt; mso-add-space: auto; mso-list: l7 level1 lfo5; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Courier New"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: "Courier New";">o<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: Calibri;">Interface de desenvolvimento para criar,
testar e executar manualmente os processos de ETL.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: 72.0pt; mso-add-space: auto; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 90.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l9 level1 lfo2; tab-stops: list 90.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">•<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Repository Manager: <o:p></o:p></span></b></div>
<div class="MsoListParagraphCxSpFirst" style="margin-left: 108.0pt; mso-add-space: auto; mso-list: l0 level1 lfo4; tab-stops: list 108.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Courier New"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: "Courier New";">o<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: Calibri;">Permite criar,
atualizar e verificar as versões dos repositórios locais e Central.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 108.0pt; mso-add-space: auto; text-align: justify;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 144.0pt; mso-add-space: auto; mso-list: l0 level2 lfo4; tab-stops: list 144.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt; mso-bidi-font-weight: bold;">–<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: Calibri;">Repositório Local: Armazena
</span><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: +mn-ea;">as definições dos
objetos do Data Services Designer (como projetos, jobs, work flows e data
flows) e metadados de origem/destino. </span><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold;"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 180.0pt; mso-add-space: auto; mso-list: l0 level3 lfo4; tab-stops: list 177.2pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; font-size: 10.0pt; mso-bidi-font-family: Wingdings; mso-bidi-font-weight: bold; mso-fareast-font-family: Wingdings;">§<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: +mn-ea;">Cada desenvolvedor deve ter seu repositório
local, ou seja, o repositório é individual</span><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;"><o:p></o:p></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 90.0pt; mso-add-space: auto; text-align: justify;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 177.2pt; mso-add-space: auto; mso-list: l0 level5 lfo4; tab-stops: list 177.2pt; text-align: justify; text-indent: -14.15pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt; mso-bidi-font-weight: bold;">•<span style="font-size: 7pt;"> </span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: +mn-ea;">Repositório Central: Componente opcional
utilizado para apoiar o desenvolvimento multiusuário.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 198.0pt; mso-add-space: auto; mso-list: l0 level5 lfo4; tab-stops: list 198.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt; mso-bidi-font-weight: bold;">•<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: +mn-ea;">Funciona como um
SharePoint => Controla a versão dos objetos desenvolvidos.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 198.0pt; mso-add-space: auto; mso-list: l0 level5 lfo4; tab-stops: list 198.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt; mso-bidi-font-weight: bold;">•<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: +mn-ea;">Apenas um repositório
central para todos os desenvolvedores. Deve-se criar o repositório Central com
segurança para que apenas usuários cadastrados tenham o acesso ao projeto e
Jobs desenvolvidos.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 90.0pt; mso-add-space: auto; text-align: justify;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 108.0pt; mso-add-space: auto; mso-list: l0 level1 lfo4; tab-stops: list 108.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Courier New"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: "Courier New";">o<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: Calibri;">Repositórios devem
estar criados no servidor de banco de dados.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: 90.0pt; mso-add-space: auto; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l9 level1 lfo2; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">•<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Server Manager: </span></b><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 2.0cm; margin-right: 0cm; margin-top: 0cm; mso-list: l12 level3 lfo3; tab-stops: list 2.0cm; text-align: justify; text-indent: -21.25pt;">
<!--[if !supportLists]--><span style="font-family: "Courier New"; line-height: 115%; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: "Courier New";">o<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">Responsável
pela execução dos Jobs do Data Services Designer. Nele vinculam-se os
repositórios locais para execução e configuração SMTP para envio de e-mail.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l9 level1 lfo2; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">•<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Management
Console <o:p></o:p></span></b></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 2.0cm; margin-right: 0cm; margin-top: 0cm; mso-list: l4 level1 lfo13; tab-stops: list 2.0cm; text-align: justify; text-indent: -21.25pt;">
<!--[if !supportLists]--><span style="font-family: "Courier New"; line-height: 115%; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: "Courier New";">o<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;"> </span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">Provê a administração e gerenciamento dos recursos
do Data Services Designer via WEB. Nele é possível</span><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">:
<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 72.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l9 level2 lfo2; tab-stops: list 72.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">–<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Agendamento, monitoramento
e execução dos Batch jobs <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 72.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l9 level2 lfo2; tab-stops: list 72.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">–<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Interrupção da execução
dos Batch Jobs <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 72.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l9 level2 lfo2; tab-stops: list 72.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">–<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Configuração dos
Repositórios Locais<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 72.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l9 level2 lfo2; tab-stops: list 72.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">–<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Configuração do
Repositório Central <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 72.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l9 level2 lfo2; tab-stops: list 72.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Times New Roman","serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">–<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Criação dos grupos e usuários
para acesso ao Repositório Central <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin: 0cm;">
<br /></div>
<h1 style="margin-left: 42.55pt; mso-list: l11 level1 lfo11; text-indent: -21.25pt;">
<!--[if !supportLists]--><span style="font-family: "Verdana","sans-serif"; font-size: 14.0pt; mso-bidi-font-family: Verdana; mso-fareast-font-family: Verdana;">1.<span style="font-family: 'Times New Roman'; font-size: 7pt; font-weight: normal;"> </span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif";">Data Services Designer</span><span style="font-family: "Verdana","sans-serif";"><o:p></o:p></span></h1>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">Interface do Data Services Designer, possui:<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: 36.0pt;">
<span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">- Barra de
menu<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: 36.0pt;">
<span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">- Project
Area,<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: 36.0pt;">
<span lang="EN-US" style="font-family: "Verdana","sans-serif"; mso-ansi-language: EN-US; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">- Local Object Library <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: 36.0pt;">
<span lang="EN-US" style="font-family: "Verdana","sans-serif"; mso-ansi-language: EN-US; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">- Star Page.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: 36.0pt;">
<span lang="EN-US" style="font-family: "Verdana","sans-serif"; mso-ansi-language: EN-US; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5-G1c-pNM8oZ5x0mdtehBbCyNtFPX0J1hU6ED4AmClUFGmqxU78MC8l1kDienOQA93Wungholx9wDHpi3TG57bacnvgodvB1-Q6VvZ-cSYxpsthEeZ06hkgIFrjmOC-EMSXzeH-QDUcY/s1600/DS1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5-G1c-pNM8oZ5x0mdtehBbCyNtFPX0J1hU6ED4AmClUFGmqxU78MC8l1kDienOQA93Wungholx9wDHpi3TG57bacnvgodvB1-Q6VvZ-cSYxpsthEeZ06hkgIFrjmOC-EMSXzeH-QDUcY/s1600/DS1.jpg" height="255" width="320" /></a></div>
<div class="MsoNormal" style="margin-left: 36.0pt;">
<span lang="EN-US" style="font-family: "Verdana","sans-serif"; mso-ansi-language: EN-US; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;"><br /></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l8 level1 lfo7; tab-stops: list 36.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Wingdings 3"; line-height: 115%; mso-bidi-font-family: "Wingdings 3"; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: "Wingdings 3";">}<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;"> </span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Project
Area: </span></b><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">Possibilita visualizar
os Jobs vinculados ao projeto, como também monitorar e verificar o log de
execução. Contêm as seguintes abas.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-left: 72.0pt; mso-add-space: auto; mso-list: l1 level2 lfo8; tab-stops: list 72.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: Arial;">•<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Designer: </span></b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold;">Criar, visualizar
e gerenciar projetos. Fornece uma visão hierárquica de todos os objetos
utilizados no processo.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 72.0pt; mso-add-space: auto; mso-list: l1 level2 lfo8; tab-stops: list 72.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: Arial;">•<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Monitor: </span></b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial;">Exibi o status das execuções dos Jobs e possibilita finalizar o processo
durante a execução.</span><span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: 18.0pt; mso-add-space: auto; mso-list: l1 level2 lfo8; tab-stops: list 72.0pt; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Arial","sans-serif"; font-size: 9.0pt; mso-fareast-font-family: Arial;">•<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Log: </span></b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-weight: bold;">Local onde se
visualiza o histórico completo de execução dos jobs.<b> </b>Também p</span><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial;">odem ser visualizados com o Data Services Management Console.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: 18.0pt; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5iuxdeQVjpaZ04TiDmmEsXavksMmoqBBrtiV00fLephFzHIeUhF81YKh8DO1qAo558dUMsKjjjy6GrcnViPRoaoDNglzeRoLRh3YKvfK5j3pg2VyC4hL1acqYnd50yOGPYB7tQNNqe7w/s1600/DS2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5iuxdeQVjpaZ04TiDmmEsXavksMmoqBBrtiV00fLephFzHIeUhF81YKh8DO1qAo558dUMsKjjjy6GrcnViPRoaoDNglzeRoLRh3YKvfK5j3pg2VyC4hL1acqYnd50yOGPYB7tQNNqe7w/s1600/DS2.jpg" height="254" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<span style="font-family: Verdana, sans-serif; font-size: 10pt;"> </span><br />
<div class="MsoNormal" style="line-height: 115%; margin-bottom: 10.0pt; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; mso-list: l8 level1 lfo7; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: "Wingdings 3"; line-height: 115%; mso-bidi-font-family: "Wingdings 3"; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold; mso-fareast-font-family: "Wingdings 3";">}<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;"> </span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; line-height: 115%; mso-bidi-font-size: 10.0pt;">Local
Object Library <o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">Job</span></b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">: Objeto
executável. Pode conter:<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-left: 53.4pt; mso-add-space: auto; mso-list: l2 level1 lfo10; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Scripts</span></b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">: Para envio de
e-mail, deleção de registros no banco de dados, habilitar e desabilitar índices
e demais verificações necessárias em banco de dados e etc.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 53.4pt; mso-add-space: auto; text-align: justify;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 53.4pt; mso-add-space: auto; mso-list: l2 level1 lfo10; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Conditional</span></b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">: Objeto utilizado
para uma condição de execução do processo.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="text-align: justify;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 53.4pt; mso-add-space: auto; mso-list: l2 level1 lfo10; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Work Flow</span></b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">: Objeto onde
seqüencia-se e ordena-se o fluxo de execução. Composto por Data Flows. Também é
utilizado para definir estratégias de tratamento de erros que possam ocorrer
durante a execução do Job (bloco Try/Catch).<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 53.4pt; mso-add-space: auto; text-align: justify;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 53.4pt; mso-add-space: auto; mso-list: l2 level1 lfo10; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 10.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Data Flow</span></b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">:</span><span style="color: #0000cc; font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: +mn-cs; mso-fareast-font-family: +mn-ea; mso-font-kerning: 12.0pt;"> </span><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Processo pelo qual
os dados de origem são transformados e carregados no destino. Envolve a
extração o tratamento e a transferência dos dados de origem de uma ou mais
fontes para uma ou mais tabelas ou arquivos de destino. <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: 53.4pt; mso-add-space: auto; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="text-align: justify;">
<b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">Projects: </span></b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold;">Agrupa<b> </b>os Jobs do processo de ETL.<o:p></o:p></span></div>
<div class="MsoListParagraph" style="margin-left: 53.4pt; mso-add-space: auto; mso-list: l6 level1 lfo6; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt;">•<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Os
J</span><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: +mn-ea;">obs devem ser associados a um projeto antes de
serem executados na área de</span><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;"> </span><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: +mn-ea;">Projeto (Project Area) do Designer para que se
possa monitorar e/ou cancelar o processo. </span><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">Datastore</span></b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">: Configuração
da conexão com o banco de dados. Contêm a lista de tabelas que serão utilizadas
no processo.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">Formats</span></b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">: Definição
dos Flat Files de origem e destino.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">Transforms:
</span></b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">Agrupa
os componentes que serão utilizados para o processo de carga e demais
transformações nos dados. Sendo os mais utilizados:<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-left: 71.4pt; mso-add-space: auto; mso-list: l10 level1 lfo9; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt;">–<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Query:
Lookups, funções e demais transformações<b><o:p></o:p></b></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 71.4pt; mso-add-space: auto; mso-list: l10 level1 lfo9; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt;">–<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">SQL:
Querys livres<b><o:p></o:p></b></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 71.4pt; mso-add-space: auto; mso-list: l10 level1 lfo9; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt;">–<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Case:
Condicional para gerar uma ou várias saídas<b><o:p></o:p></b></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 71.4pt; mso-add-space: auto; mso-list: l10 level1 lfo9; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt;">–<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Merge:
União dos dados vindos de várias origens <b><o:p></o:p></b></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 71.4pt; mso-add-space: auto; mso-list: l10 level1 lfo9; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt;">–<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial;">Key_Generation: Geração da Surrogate Key</span><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;"><o:p></o:p></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 71.4pt; mso-add-space: auto; mso-list: l10 level1 lfo9; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span lang="EN-US" style="font-size: 10.0pt; mso-ansi-language: EN-US;">–<span style="font-size: 7pt;">
</span></span><!--[endif]--><span lang="EN-US" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-font-family: Arial;">History_Preserving: Slowly Change Dimension 2</span><b><span lang="EN-US" style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-ansi-language: EN-US;"><o:p></o:p></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 71.4pt; mso-add-space: auto; mso-list: l10 level1 lfo9; text-align: justify; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-size: 10.0pt;">–<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt; mso-bidi-font-family: Arial;">Table_Comparison: Update, SCD 1</span><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;"><o:p></o:p></span></b></div>
<table align="left" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td height="247" width="32"></td>
</tr>
<tr>
<td></td>
<td><br /></td>
</tr>
</tbody></table>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 71.4pt; mso-add-space: auto; text-align: justify;">
<!--[if gte vml 1]><v:rect id="_x0000_s1027" style='position:absolute;
left:0;text-align:left;margin-left:26.55pt;margin-top:188.15pt;width:195pt;
height:190.5pt;z-index:3' filled="f" fillcolor="white [3201]" strokecolor="#c0504d [3205]"
strokeweight="4.5pt">
<v:shadow color="#868686"/>
</v:rect><![endif]--><!--[if !vml]-->
<!--[endif]--><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;"> </span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 71.4pt; mso-add-space: auto; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjug7UbyvbAp87WcAJ8_0w3_7BeAwZdMEo_zMySgE9ZSiIFVVsZbhuFhaagkuUrRDB31NOh227lTEHKqIYczG9Ju9ByTYcvLKWnbE2WRvppb6vq7wnnwMXNs1b3UitijJ1jQpKz1VCWOE/s1600/DS3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjug7UbyvbAp87WcAJ8_0w3_7BeAwZdMEo_zMySgE9ZSiIFVVsZbhuFhaagkuUrRDB31NOh227lTEHKqIYczG9Ju9ByTYcvLKWnbE2WRvppb6vq7wnnwMXNs1b3UitijJ1jQpKz1VCWOE/s1600/DS3.jpg" height="254" width="320" /></a></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 71.4pt; mso-add-space: auto;">
<!--[if gte vml 1]><o:wrapblock><v:shape id="Imagem_x0020_2" o:spid="_x0000_s1029"
type="#_x0000_t75" style='position:absolute;left:0;text-align:left;
margin-left:29.55pt;margin-top:18.5pt;width:449.8pt;height:5in;z-index:2;
visibility:visible;mso-wrap-style:square;mso-wrap-distance-left:9pt;
mso-wrap-distance-top:14.2pt;mso-wrap-distance-right:9pt;
mso-wrap-distance-bottom:14.2pt;mso-position-horizontal:absolute;
mso-position-horizontal-relative:margin;mso-position-vertical:absolute;
mso-position-vertical-relative:text'>
<v:imagedata src="file:///C:\Users\ERICK~1.FUR\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title=""/>
<w:wrap type="topAndBottom" anchorx="margin"/>
</v:shape><![endif]--><!--[if !vml]-->
<!--[endif]--><!--[if gte vml 1]></o:wrapblock><![endif]--><br clear="ALL" />
<b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;"> </span></b><b><span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;"> </span></b></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin: 0cm;">
<b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">Start
Page:</span></b><span style="font-family: "Verdana","sans-serif"; mso-bidi-font-size: 10.0pt;">
<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-left: 58.7pt; mso-add-space: auto;">
<br /></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: 58.7pt; mso-add-space: auto;">
<span style="font-family: "Verdana","sans-serif"; font-size: 10.0pt;">Local para o
desenvolvimento das rotinas de ETL.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWPgdGhlE7XCEgGPPVi4IpAW7TcAL69Q1nJuC-5GOyjyx1BULS1TV8Sj20Mie4N3l1I8JIWBFPpW45I9MIztNp9UFcGLmFYMX42X5JAKSZhHuhXbMPjgG3JrxnWaurhHUApgJn7oidkdU/s1600/DS4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWPgdGhlE7XCEgGPPVi4IpAW7TcAL69Q1nJuC-5GOyjyx1BULS1TV8Sj20Mie4N3l1I8JIWBFPpW45I9MIztNp9UFcGLmFYMX42X5JAKSZhHuhXbMPjgG3JrxnWaurhHUApgJn7oidkdU/s1600/DS4.jpg" height="181" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0tag:blogger.com,1999:blog-6932166992077547298.post-24064340779084394872013-07-16T10:23:00.003-07:002013-07-16T10:23:50.293-07:00PL/SQL - Carga dimensão Tempo (Time Dimension Load)<br />
<div align="center" class="MsoNormal" style="text-align: center;">
<b><span lang="PT-BR">Carga da Dimensão
Tempo em PL/SQL<o:p></o:p></span></b></div>
<div align="center" class="MsoNormal" style="text-align: center;">
<b><span lang="PT-BR">(Time Dimension load
in PL/SQL)<o:p></o:p></span></b></div>
<div align="center" class="MsoNormal" style="text-align: center;">
<b><span lang="PT-BR"><br /></span></b></div>
<div class="MsoNormal">
<span lang="PT-BR">Carga da
dimensão de tempo com a seguinte estrutura em snow flake:<o:p></o:p></span></div>
<div class="MsoNormal">
(Load of the time dimension with the following snow flake
schema)<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_h20sWiCfR9N5Ry47JvNAGzh0XmLfh2NS3MYrgbFE8bkZFAB_nhm6AkAf2Uzr5kZKVQzTGR61xjtqjEndCM12tNw31-Y8f_XHKw1Bh-iltUWyK7jJZwXMo-NZcQT4feXQThDwh9kU7Lw/s1600/Time_Dimension.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_h20sWiCfR9N5Ry47JvNAGzh0XmLfh2NS3MYrgbFE8bkZFAB_nhm6AkAf2Uzr5kZKVQzTGR61xjtqjEndCM12tNw31-Y8f_XHKw1Bh-iltUWyK7jJZwXMo-NZcQT4feXQThDwh9kU7Lw/s1600/Time_Dimension.jpg" height="320" width="178" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="PT-BR">Para efeito
didático o código carrega poucos campos nestas estruturas, porém é de fácil
alteração para inclusão de novos cálculos de tempo.<o:p></o:p></span></div>
<div class="MsoNormal">
(For didactic purposes the code loads few fields, but it is
easy to change to include new time calculations.) Note that for english
language natives, the six month period is unusual and can be dropped of the
structure.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><span lang="PT-BR">--Carga dimensão Ano (Year dimension load)<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span lang="PT-BR"><br /></span></b></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
declare<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataIni DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataFim DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data_Movel DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
BEGIN<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataIni :=
to_date('2000/01/01','yyyy/mm/dd');<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataFim :=
to_date('2040/12/31','yyyy/mm/dd');<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := DataIni;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHILE Data <= DataFim LOOP<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
INSERT INTO TRDIM.ANO ( ANO
)<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
VALUES (
TO_CHAR(extract(YEAR from Data)) );<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data :=
add_months(Data,12);<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := add_months(Data,1)
- extract(DAY from (add_months(Data,1)));<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END LOOP;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
COMMIT;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END;<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>--Carga dimensão
Semestre (Six month period dimension load)<o:p></o:p></b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
declare<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataIni DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataFim DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data_Movel DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
BEGIN<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataIni :=
to_date('2000/01/01','yyyy/mm/dd');<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataFim := to_date('2040/12/31','yyyy/mm/dd');<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := DataIni;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHILE Data <= DataFim LOOP<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
INSERT INTO TRDIM.SEMESTRE(SEMESTRE, DESCRICAO_SEMESTRE,
ANO )<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
VALUES<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
(<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR
from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,1,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,2,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,3,'02'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,4,'02')<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,1,'1º Semestre'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,2,'1º Semestre'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,3,'2º Semestre'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,4,'2º Semestre'), <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR from Data)) <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
);<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := add_months(Data,6);<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := add_months(Data,1)
- extract(DAY from (add_months(Data,1)));<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END LOOP;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
COMMIT;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END;<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>--Carga dimensão
trimestre (Quarter dimension load)<o:p></o:p></b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
declare<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataIni DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataFim DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data_Movel DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
BEGIN<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataIni :=
to_date('2000/01/01','yyyy/mm/dd');<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataFim :=
to_date('2040/12/31','yyyy/mm/dd');<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := DataIni;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHILE Data <= DataFim LOOP<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
INSERT INTO TRDIM.TRIMESTRE(TRIMESTRE,
DESCRICAO_TRIMESTRE, SEMESTRE,ANO)<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
VALUES<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
(<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR
from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,1,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,2,'02'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,3,'03'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,4,'04')<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,1,'1º Trimestre'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,2,'2º Trimestre'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,3,'3º Trimestre'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,4,'4º
Trimestre'), <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR
from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,1,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,2,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,3,'02'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,4,'02'), <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR
from Data)) <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
);<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := add_months(Data,3);<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := add_months(Data,1)
- extract(DAY from (add_months(Data,1)));<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END LOOP;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
COMMIT;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal">
<b><span lang="PT-BR">--Carga dimensão mês (month dimension load)<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span lang="PT-BR"><br /></span></b></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
declare<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataIni DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataFim DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data_Movel DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
BEGIN<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataIni :=
to_date('2000/01/01','yyyy/mm/dd');<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataFim :=
to_date('2040/12/31','yyyy/mm/dd');<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="PT-BR">Data := DataIni;<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="PT-BR">WHILE Data <= DataFim
LOOP<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="PT-BR"> INSERT INTO TRDIM.MES (MES,
DESCRICAO_MES, ANO, SEMESTRE, TRIMESTRE)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span lang="PT-BR"> </span>VALUES<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
(<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR
from Data)) || TO_CHAR(Data, 'MM'),<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
(CASE extract(MONTH
from Data)<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (1) THEN ('JANEIRO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (2) THEN ('FEVEREIRO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (3) THEN ('MARÇO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (4) THEN ('ABRIL') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (5) THEN ('MAIO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (6) THEN ('JUNHO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (7) THEN ('JULHO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (8) THEN ('AGOSTO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (9) THEN ('SETEMBRO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (10) THEN ('OUTUBRO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (11) THEN ('NOVEMBRO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHEN (12) THEN ('DEZEMBRO') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END) || ' DE ' ||
TO_CHAR(extract(YEAR from Data)),<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR
from Data)),<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR
from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,1,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,2,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,3,'02'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,4,'02'),<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR
from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,1,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,2,'02'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,3,'03'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,4,'04') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
);<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := add_months(Data,1);<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := add_months(Data,1)
- extract(DAY from (add_months(Data,1)));<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END LOOP;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
COMMIT;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal">
<b>--Carga dimensão Data
(Day dimension load)<o:p></o:p></b></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
declare<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataIni DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataFim DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data_Movel DATE;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
BEGIN<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataIni :=
to_date('2000/01/01','yyyy/mm/dd');<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
DataFim :=
to_date('2040/12/31','yyyy/mm/dd');<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := DataIni;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
data_movel := DataFim;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
WHILE Data <= DataFim LOOP<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
INSERT INTO TRDIM.DATA
(DATA,DIA_UTIL,ANO,SEMESTRE,TRIMESTRE,MES)<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
VALUES<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
(<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data,<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
CASE WHEN ( TO_NUMBER(
TO_CHAR (Data, 'D') ) IN (1,7) ) THEN ('N') <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
ELSE ('S') END,<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR from
Data)),<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR from
Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,1,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,2,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,3,'02'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,4,'02'),<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR
from Data)) || DECODE(TO_NUMBER(TO_CHAR(Data,'Q'))<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,1,'01'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,2,'02'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,3,'03'<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
,4,'04'),<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
TO_CHAR(extract(YEAR
from Data)) || TO_CHAR(Data, 'MM')<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
);<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Data := Data + 1;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END LOOP;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
COMMIT;<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
END;<o:p></o:p></div>
Erick Fursthttp://www.blogger.com/profile/14645667811503698053noreply@blogger.com0