Staging area – Retains data from 7 days to 1m other.
Both are interdependent stages
Used for doing Data Backup
Compress the data using COMPESS (or) GZIP Commands.
8 records are compressed to 1 record.
Expand the Compressed data using UNCOMPRESS or GUNZIP.
Encrypts and Compresses
It is a processing Stage used to cell the operators on to the Data stage
The stage is an operator prebuilt component
IBM developed a tool called X – Migratory Converts Server jobs to parallel jobs Conversion rate = 70%.
X – Migratory when it is migratory / converting Server jobs to parallel jobs it is going to substitute those stages which are not these in a parallel environment with the generic stage call the functionality of the stage with its operator.
Reverse pivot converting columns to rows
Pivot converting rows to columns
Ex:- input:-
11 A HYD
22 B SEC
33 C DEL
Output
| 11 | A | 11 | 11 | HYD | ||
| A | HYD | 11 | A | HYD | ||
| HYD | B | 22 | 22 | Sec | ||
| 22 | SEC | 22 | B | Sec | ||
| B | (or) | C | 33 | (or) | 33 | Del |
| Sec | Del | 33 | C | Del | ||
| 33 | ||||||
| C | ||||||
| Del |
Sequential file pivot Data set
Primary.txt propertiesoutput
Columns Derivation length
COL1 E ID, E NAME, STATE 100
COL2 STATE 10
Ok
Inclined to build a profession as Datastage Developer? Then here is the blog post on, explore Datastage Training
(a) oracle – XML format
(b) XML – file format
XML outputColumns Description /EMP/ EMP No /EMP/ EMP NAME /EMP/ JOB /EMP/ MGR
Transformation setting single rowoptionàwrite output to a file new folder Data XML
XML OUT.XMLE :/Data XML/XML OUT.XML ok.
We can see the XML files in the folder that we created. That is Data XML
each and every record is created in an XML format.
File pattern Dataxml.xml load with single column rec varchar 100
Input XML Source column xml document output columns load import xml Table Definition open Data XML.
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
