39. DWH Nav Steps

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Repository Manager:

1.Rt clk on Repository(veerurepo)---2.Connect---3.Enter Username---4.Enter Password--5.Connect.

1.Clk Folder menu---2.Create----3.Enter name(Vfolder)---4.Ok---5.Close window.

Designer:

1.Rt clk on Repo(veerurepo)---2.Connect---3.UN&Password--4.Connect--5.Clk folder (Vfolder)—6.Clk source folder----

Tools---Source Analyzer--1.Sources---2.Import from Database.---3.Enter ODBC dsn------ 4.Username( in caps SCOTT)---5.Enter owner name (in caps SCOTT)---6.Enter Password (tiger)---7.Connect.—8.select tables---9.ok.

Note: If DSN is not created the procedure is as follows.

1.Clk on Ellipse button.---2.System DSN---3.Add---4.Select oracle in OraDB10g-home1(driver)--5.Finish---6.Enter kodad DSN in Data Source Name---7.Select TNS service name (server)---8.User Id (scott)---9.Test connection---10.Password(tiger)---11.Ok---

12.Ok(Oracle ODBC Driver Configuration window)---13.Ok(ODBC data source Adm window)--14.Select ODBC data source(kodad DSN)---15.User name (SCOTT)---16.Owner name (SCOTT)---17.Password(tiger)---18.Connect.---19.select tables---20.ok.

Note: UN must be in Caps.

Tools---Warehouse Designer---1.Clk Target folder------2.Targets---3.Create---4.Enter table name(vtable)---5.select the database---6.create---7.done---8.Dbl clk on Target table--9.Columns tab---10.Clk on icon---11.Enter the fields---12.Apply---13.Ok—14.Targets---15.Generate/ExecuteSQL---16.Enable selected Tables---17.Create table---18.Primary key—19.Connect----20. Enter ODBC dsn----21.User name---22.Password ----23.connect-----24.Generate and Execute button---25.close---26.Message box ---27.OK.

Tools---Transformation Developer----1.Create---2.select Transformation type----3.Enter name--4.Create---5.Done---6.Dbl Clk Transformation----7.Clk on icon to enter the fields---8.Do Editings----9.Validate---10.ok---11.Apply---12.ok.

Tools--Mapping Designer---1.Goto navigator---2.Explore source folder---3.Drag & drop source tables—4.Explore target folder---5.Drag & drop targrt tables---6.Explore Transformation—7. Drag and drop Transformation----8.Link Source,Transformation,Target---9.Mappings----10.Validate.

------------------------------------------------------------------------------------------------------------

WORKFLOW MANAGER:

1.From left panel----2.select Task folder----3.Tools---4.Task Developer---5.Tasks---6.create---7.select mapping---8.ok---9.done---

10.connections---11.Relational---12.new---13.Select DB (oracle)---14.ok---

15.enter name---16.UN---17.Pwd---18.connect string---19.code page---20.ok---

21.Repeat from 12 to 20 steps.---22.close window---23.Dbl clk on task(EDIT)---

24.mapping tab---25.select sources from left panel---26.clk down arrow in value column in TYPE row---27.select veerusource in Relational connection Browser---28.ok---

29.select target from left panel---30. clk down arrow in value column in TYPE row .---31.select veerutarget in Relational connection Browser and click normal ---32.ok---33.Apply---34.ok---35.Tools---36.Workflow Designer---37.workflows---38.create---39.enter name for workflow(veeruworkflow)---40.select server and clk Ok---41.clk session from left panel---42.Drag and drop veerutask to right panel---43.Establish link---44.Save---

45.workflow--- start worlflow---select * from Target Table(vtable) for OUTPUT.

In DATABASE

For Source/Metadata Database

Connect sys as sysdba;

Create user veerus identified by veerus;

Grant connect, resource to veerus;

Connect veerus/veerus;

Select * from tab;

For Target Database

Connect sys as sysdba;

Create user veerut identified by veerut;

Grant connect, resource to veerut;

Connect veerut/veerut;

Select * from tab;

To copy tables

Connect scott/tiger;

Grant select on emp to veerus;

To paste tables into our sources

Connect veerus/veerus;

Create table emp as (select * from scott.emp);

Select * from tab;

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Precautions

1.In source Analyzer---------- Remove all the FKs.

2.In Warehouse Designer---- Enable selected tables, create table, Pk, connect,

Generate and Execute, close.

3.In Workflow Manager----- In create workflow window after naming select server.