Designer Implementation in Data Stage

Designer

(a) Import/ Export (b)Node configuration (c)Advanced find  

 (a) Import/ Export

We can import and export entre project or individual components of repository To more jobs from 1 project to other job backups  

Export :- (Project – India /DWS)

    C :/ Document and setting / admin/ desktop/Backup. new àJob components to export [Export job designs with executables  read only items] Type of export    DSX  (platform dependent)   XML (independent)  àExportàExport complete

To add a new file to already existing one

• Append to existing file

We are Storing the back up file in the Desktop Desktop  click on Backup. New    openyou can view an basic Script

We can also view through command line prompt

DS export DS import Open a Designer client – with new project :- Import :-   (project – India/ Analyzer  project) Data stage  components   import from file (Browse the file that we saves in export)

• Import Selected
• performance analysis  ok  

 

Data Stage Import
Type 1	Name                       Status
Table definition ………………….
Job  definition ………………
Job definition ………………..

Multiple  Job Compiler

To compile  n no. of Jobs   Tools  Multiple Job Compile  parallel  Next Remove all And select required Jobs  Next Next Start Compile  show compile report   when finished Opens a Note pad

• Data stage Compilation Report

  Server : India Project :dws Started at : Finished at : Time Taken : 3items processed 2 items compiled Successfully 1 items  failed compilation Compile information   list compiled ok Can Multiple users run the same job at some time ? Sol:- when 2  or more people run the same job at same time with different parameters, use an option / enable the job option Allow Multiple instances Open any job  job properties parameters Can 2 persons open the job at same time ? Sol :-   yes 1^st person will have Read, write options 2^nd   person will have only Read option Note:- w can’t run the Multiple jobs at same time in Designer we can run Multiple jobs at same time in director  To run Multiple Jobs at same time in director  It asks for Invocation Id

Invocation Id

A user defined identification to run a job for that instance It is creating an instance In the output, different users should give different output extensions   Example:-   abc  (1.txt)  abc  (2.txt) Tool  Run Director  click on the jobàIn vocation id1000Any number  

Scheduling

Click on any Job  Right click  Add to schedule   Set the time   (b) Node Configuration Its not our Role, DSA will do it For Sometimes we need to run a job on particular  node Configuration, then we use Node configuration.   Example A Data set  is created on 4 nodes abut we created a job on 2 nodes àwhile we run, it aborts à SO, we need to make Sure that it run on 4 nodes using Node Configuration.  

Questions based on Node Configuration 

What is a Node ? Sol :- logical CPU What is Node Configuration ? Sol :- Technique of creating logical CPU’s How to See Nodes ? Sol :-  3 ways to see Nodes :-

1. check at logs
2. configuration file
3. Job Score

Learn DataStage by Tekslate - Fastest growing sector in the industry.
Explore Online DataStage Training and course is aligned with industry needs & developed by industry veterans.
Tekslate will turn you into DataStage Expert.

(a) check at logs

Tools  run director  click on log Select  Main program  : APT  configure file Node details are displayed

(b) configuration file

(Real time it is disabled) Tools configuration  default  node details are displayed

(c) Job Score

Job properties  parameters Add environment variables ReportingReport Score Report Score = True  Report comes in log What are Node Components Sol :-

• Node Name - logical CPU name
• fast Name - Server name or system name
• Pools – logical area where stages are executed
• resource – memory associated with node

  Disk – permanent   “C :/ IBM / Information Server / Server/ Datasets”   Scratch disk  - temporary   “C :/ IBM / Information Server / Server/ Scratch” What is default config file name ? Sol :- every job is exe on default. Apt   (actual parameter) How many nodes in your project ? Sol :- 8 or 16  (2^0, 2^1)…………. How to create a new Node Configuration file ? Sol :-   Tools  configurations  copy the code  Select New   part the Code 3 or 4  times   change the node Names        Node 1 Node2 Node 3……Save configuration check  configuration configured    ‘0’ errors detected How to run a job on a Specific Config file ? Sol :-  $apt- config- file Job properties  parameters  Add  Environment variables Parameter name  $ apt – config – file   ok  

Compile and RUN

We can browse and change the path if uni processing System with 1 CPU needs minimum 1 node  to run a job, then for           SMP with 4 CPU needs How many minimum nodes ? Sol :-    1 Node For indepth understanding of DataStage click on

• Introduction to DataStage
• Architecture of Data Stage
• Oracle Enterprise in Data Stage
• SCD(Slow changing Dimension) in Data Stage
• DataStage Tutorials