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 …
If sequence has 4 jobs, How to restart the run from 2nd job again? Answer: Using check point concept to make it restart. Difference between Resource Disk and Resource Scratch …
RANK Function: RANK function returns the rank of a value in a group of values. It is similar to DENSE_RANK function. The rank function can cause non-consecutive rankings if …
