Lalitha Mohanasundaram·Sep 26NTILE() vs CUME_DIST(): Turning Window Functions into Business ValueNTILE() and CUME_DIST() both help Data Engineers understand where data stands within an ordered dataset — but they answer different…
Lalitha Mohanasundaram·Aug 14How RAG is Revolutionizing Data EngineeringRetrieval-Augmented Generation (RAG) is transforming data engineering by enabling Enterprise Knowledge Assistants that provide instant…
Lalitha Mohanasundaram·Aug 14From Prompt Engineering to Governance Engineering: The New Layers of AI EngineeringBuilding reliable AI systems is no longer just about choosing a powerful LLM or writing a good prompt. Modern AI systems require multiple…
Lalitha Mohanasundaram·Aug 8Why Vector Databases Are Critical for Modern AI and Data EngineeringVector databases are becoming a core technology in modern AI and data engineering because traditional databases cannot efficiently handle…
Lalitha Mohanasundaram·Aug 8If TPT replaces FastLoad, MultiLoad, FastExport, and TPump, why are we still using BTEQ?It’s one of the most common Teradata interview questions — and a point of confusion for many data engineers entering enterprise…
Lalitha Mohanasundaram·Jul 26DST changes can silently break intraday ETL pipelines — causing missing or duplicate data during…Intraday ETL pipelines depend heavily on timestamps, scheduler windows, and incremental load logic. During Daylight Saving Time (DST)…
Lalitha Mohanasundaram·Jul 26Duplicate Data in ETL Pipelines: The Silent Threat to Data AccuracyA successful ETL pipeline does not always mean accurate data. Duplicate records can silently inflate revenue, customer counts…
Lalitha Mohanasundaram·May 19Fact and Dimension tables can make or break our analytics — they are the foundation of every data…In Database, raw data becomes useful only when it is structured into Fact and Dimension tables. Without this structure, data remains…
Lalitha Mohanasundaram·May 19Who logged into Teradata Database, when, and from where? DBC.LogOnOffV gives the answer instantly.DBC.LogOnOffV is our go-to system view for tracking user sessions — helping to monitor activity, troubleshoot issues, and strengthen…
Lalitha Mohanasundaram·Apr 13Detecting AMP Data Skew in Teradata Using DBC.TableSizeVIn Teradata Database, AMP-level data skew can be quickly confirmed by analyzing space distribution across AMPs(Access Module Processors)…