Category: DATASTAGE TUTORIAL
If you wonder what is dsenv file in DataStage, you can visit our previous post on dsenv file. For some ODBC connections, plug-ins, and connectors, and for interactions with …
We installed DataStage infosphere server in our windows server system with the required details. Actually we are able to run all the jobs and stages after installation except Transformer …
In this DataStage scenario, we need to get the output as reverse letters in a given word. Input Data: almost big datastage etl navy Output Data: tsomla gib egatsatad …
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 join stage? Let see! …
In several processing stages, we 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 …
Question: Input-1: 1 2 3 4 5 6 Input-2: 4 5 6 7 8 9 Output-1: 1 2 3 Output-2: 4 5 6 Output-3: 7 8 9 Solution: This …
The .odbc.ini file gives information about connecting to the database (wire protocol drivers) or the database client (non-wire protocol drivers). If your system uses a mix of drivers, your …
The Datastage configuration file is a master management file (a text file which sits on the server side) for jobs which describes the parallel system resources and design. The configuration …
