Group Discounts available for 3+ students and Corporate Clients

Staging Area in DataStage

Miscellaneous Stage

Staging area – Retains data from 7 days to 1m other.

Compress And Expand

Both are interdependent stages

Used for doing Data Backup

Compress Stage 

Compress the data using COMPESS   (or) GZIP Commands.




118 records are compress to 1 record.

Expand Stage

Expand the Compressed   data using UNCOMPRESS or GUNZIP.



Encode and Decode 

Encrypts and Compresses



It is a processing  Stage used to cell the operators on to the Data stage

11Stage is an operator  11prebuilt component




IBM development a tool called X – Migratory 11Converts Server jobs to parallel jobs 11 Conversion rate = 70%.

11X – Migratory  when it is migratory / converting Server jobs to parallel  jobs it is going to substitute those stages which are not these in parallel environment with the generic stage call the functionality of the stage with its operator.


Reverse pivot 11 converting columns to rows

Pivot 11converting rows to columns

EX :-     input :-

11   A    HYD

22   B   SEC

33  C    DEL


11 A 11 11 HYD
HYD B 22 22 Sec
22 SEC 22 B Sec
B (or) C 33 (or) 33 Del
Sec Del 33 C Del

Sequential file 11pivot11 Data set

     Primary.txt                  properties11output

Columns                 Derivation                        length

COL1                   E ID, E NAME, STATE           100

COL2                 STATE                                             10


11         Ok

Interested in mastering DataStage?
Check out this blog post to learn more DataStage Tutorials.


(a)  oracle – XML format

(b)    XML – file format

  • oracle enterprise 11XML output

Columns 11Description 11 /EMP/ EMP No   /EMP/ EMP NAME   /EMP/ JOB /EMP/ MGR

11Transformation setting    single row11optionàwrite output to a file 11new folder11 Data XML 11XML OUT.XML11E :/Data XML/XML OUT.XML11 ok.

11We can see the XML files in the folder that we created.  That is Data XML

11each and every record is created an XML format.

Sequential file àXML inputàSequential file

11 File pattern  11Dataxml.xml 11load with single column rec varchar 100

Input 11XML Source column  11xml document 11output11 columns 11 load 11 import xml Table Definition  11open 11Data XML.

For indepth understanding of DataStage click on

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on Staging Area in DataStage"

Leave a Message

Your email address will not be published. Required fields are marked *


Please Enter Your Details and Query.
Three + 6