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 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 …
You can practice the above questions and along with a few more by watching the below video: Previous Article: DataStage Interview Questions-4
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 …
Difference between Procedure and Function? Function must return a value and procedure need not. Function can be used in SQL queries with some restrictions. Procedure cannot be called directly …
