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 …
While you are working on Unix environment, sometimes you might need to troubleshoot the errors/issues that caused the abnormal behavior of scripting and commands that related to Unix. In …
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 6Input-2: 4 5 6 7 8 9Output-1: 1 2 3Output-2: 4 5 6Output-3: 7 8 9 Solution: This problem can be solved by …