Category: DATASTAGE TUTORIAL
Buffering could be a technique used in the DataStage jobs to make sure a constant and uninterrupted flow of data to and from stages in such a way that …
In several processing stages, you can choose or set the sort criteria (i.e. an link or “in-stage” sort). When you do that, one of those tiny “Sort” icons show …
You know it already, the Join stage doesn’t offer reject handling for unmatched records (such as in an Inner Join scenario). So how can we capture unmatched records from …
In this DataStage scenario, You need to get the output as reverse letters in a given word. Input Data: almost big datastage etl navy Output Data: tsomla gib egatsatad tle …
You can automate the comparing DataStage jobs across environments or same environments using a diffapicmdline.exe file. This is provided by IBM and resides in C:\IBM\InformationServer\Clients\Classic directory. We need to pass …
Input Records: 123,Naveen 124,Joe 125,Gary 124,Joe 126,Mahesh 127,Bob 126,Mahesh 124,Joe We need to capture the duplicates from above data using Remove Duplicate stage along with any other stage. Expected …
“RDBMS code 6706: The string contains an untranslatable character.” Did you get this type of error in DataStage while loading data into Teradata or any other database. If yes, …
This is the basic concept we need to learn after code/develop DataStage jobs. In this post, I will explain how to export the jobs from one datastage server and …