Fetch Metadata of View in Teradata via HELP
Recently someone in my team asked me how to fetch column list along with datatype from VIEW definition via jdbc connection. I proposed couple of… Read More »Fetch Metadata of View in Teradata via HELP
Error – Select with Grant Option required
“An owner referenced by user does not have SELECT WITH GRANT OPTION access to DB_Name.Table_Name.Col_Name “. This is very common error related with privileges granted… Read More »Error – Select with Grant Option required
How to write a BTEQ Script in Teradata
In most of the Teradata environment I have seen the preferred medium to call BTEQ is shell script. It means that Teradata developer will write… Read More »How to write a BTEQ Script in Teradata
Teradata combine rows into single value
Few years ago, I shared a post to “Convert Multiple Rows into Single Row” using recursive queries. Though it solves the problem and gives the… Read More »Teradata combine rows into single value
ROWS BETWEEN in Analytical Function in Teradata
ROWS BETWEEN is used in Teradata to determine group for calculating aggregation in Analytical Functions. Whenever you use window functions or OLAP functions you specify… Read More »ROWS BETWEEN in Analytical Function in Teradata
SCD-2 in Teradata
In SCD (Slowly Changing Dimension) type 2, we have to store all the historical information about any Dimension. So unlike SCD-1, we cannot simply overwrite… Read More »SCD-2 in Teradata