Datastage 8.1 Config file/ Datastage 8.1 Tractable script|| Datastage 8.1 Notes

Datastage 8.1 Config file/ Datastage 8.1 Tractable script

Datastage 8.1 is a ETL Tool.

Datastage 8.1 using to extract he data from any database source and Trance for one location t another location with using some stages and Loding the data in any target system. His is called ETL or Data Warehousing.

In this transformation and loading and extracting for using configuration file and tractable script. How to using datastage 8.1 tractable script is steps wise information is given below. And datastage 8.1 Config file total information and database details are given bellow.

  

Steps for using the Datastage 8.1 Tranctable script:

Server:/home/prabhakar$

Example:

Server:/home/prabhakar$ cd/

Server:/$ cd  /Data/Script

Server:/Data/Script$ls

Deletetab.sh     Trunctab.sh

It will show the list of script files in the Script files

Server:/Data/Script$sh  Trunctab.sh “DBname” “Userid” “Password” “Schemaname.tabalename”

Create table syntax:

Create Schema “Schemaname”

Create table “schemaname.tablename”

(

“Field1” datatype(size),

“Field2” datatype(size),

“Field3” datatype(size),

“Field4” datatype(size),

“Field5” datatype(size)

 Field6” datatype(size),

“Field7” datatype(size),

“Field8” datatype(size),

“Field9” datatype(size),

“Field10” datatype(size)

)

GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE "Schemaname.Tablename" TO Group "Groupname";

Using Script in job properties before subroutine or After Sub routine:

Before sub routine: ExecSh

Input Value

/DE/Script/Deletetab.sh #Servername # #UserId# #Password#  #schemaname.TableName#

Datastage 8.1 Cofnfig file :

How to create New configuration File by Using Default Configuration file(Default.Apt)

Goto Tools->Configuration-> select default from configuration drop down list

Copy the content of Default configuration file  and  select “New” and Paste the content of default configuration file content and now remove which ever the nodes are not required and click on save and Save configuration as provide the configuration file Name “2Nodeconfigfile”

Step2:select the environment variable APT_CoONFIG_FILE  at job parameters

Step3:When we trigger the job then prompt will display the default conguration file and change the file name as “2Nodeconfigfile” Now your job will run on 2 node configuration file

Click Here to Datastage 8.1 Full Notes :

Click Here to More Datastage 8.1 Notes :