Datastage 8.5 Enhacements
It was more faster than before versiobs.
All the tasks become faster than previous version 8.1 .
Tasks are like save, renaming, compiling etc.
The run time of the jobs has been improved.
In Datastage transformer Stage is one of the important stage.
In Datastage 8.5 , just got better than before version..
Transformer looping has been included in the transformer stage by I.B.M
There are two types of looping available here.
Where we can output multiple O/P( Output ) links for single I/P( Input Link) Link.
For Example:
Input:
Marketing_person City-1 city-2 city-3
James Bond Washington Newyork Newjersey
Output will be
Marketing_person City
James Bond Washington
James Bond New York
James Bond New Jersey
This achieved with the new system variable @ ITERATION
System Variables:
@ ITERATION : used in the looping mechanism
LastRow(): Indicated the last row in the job
LastRowInGroup(): will return the last rown in the group based on the key.
- Basic Introduction about DataStage (ETL) tool Now need to worry about searching my videos. Added videos to my playlist and here's the link.
- Convert IBM DataStage to Informatica PowerCenter. Posted by: Informatica Professional Services. This sample can be used with any version of Data Transformation. HelloCan we Migrate DataSatge 7.5.1 Server jobs to Informatica PowerCenter?If yes can I get a trial version so we can do the demo. Sep 24 2013, 10:43 AM.
Infosphere Datastage Trial Version
Infosphere Datastage
IBM® DataStage® products offer real-time data integration for access to trusted, high-quality data. AI-based design accelerators enhance productivity, while the ability to design your extract, transform and load (ETL) jobs once and deploy across data lakes and cloud environments delivers agility and cuts costs.