No difference is there, both commands gives the same result. If we copy the file, modified time will be changed. If we move the file there will be no …
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 …
The simplest and common way to do this would be by using the command: where $LOGFILE is an environment variable corresponding to the path to the log file to …
Below sed used to remove special characters from file. $ cat emp_new.txt Michael,10#$ Bob,20^& Smith,30@! Will,20() Joe,$30+_ $ sed -e ‘s///g’ emp_new.txt Michael,10 Bob,20 Smith,30 Will,20 Joe,30 …
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! …
Lets take a look at differences between INTERVAL and ADD_MONTHS() in Teradata. This post mainly focused on where to use ADD_MONTHS() over INTERVAL function in Teradata. INTERVAL is a …
