Category: DATASTAGE TUTORIAL
We know we can give hard coded sheet name or parameterized sheet name while reading excel data from unstructured data stage. But the problem comes when you want to …
We know regular statuses that we observe in DataStage director. Some common statuses are- Not Compiled Compiled Running Finished Finished (see log) Aborted Crashed Sometimes when you trigger any …
The WebSphere DataStage server has a centralized file for storing environment variables called dsenv in $DSHOME. $DSHOME identifies the WebSphere DataStage installation directory. The default directory is /opt/IBM/InformationServer/Server/DSEngine. You …
As a developer, sometimes we need same dataset that should be used in another datastage server. Like it can be from Development server to Production server or Production to …
What is RCP in DataStage? InfoSphere DataStage is also flexible about meta data. It can cope with the situation where meta data is not fully defined. You can define …
Sometimes while working with the joins/lookups you may get the following warning in DataStage: EMP_NAME field is given for information purpose and it can be any column other than …
If you are working with a job that contains hundreds of columns, sometimes we have to change some of the properties in all the columns. It is time-consuming to …
We can use the Field function in DataStage to return one or more sub strings that are located between specified delimiters in string. Syntax: Field(%string%,%delimiter%,%occurrence%,) delimiter evaluates to any …