Data Developer insights @data@mastodon.lt
- Gytis blog
- @gytis@blog.gyt.is
- More federation
- https://fediverse.dev
- Liberapay
- https://liberapay.com/gytis
ETL (Extract, Transform, Load), SQL (Structured Query Language), data modeling, databases and bits of big data. Microblog written by @gytis
Joined Jan 2019
Efficient Slowly Changing Dimension type 1 in #PowerCenter : separate INSERT detection port (record doesn't exist on target) from UPDATE port (check all columns for changes) and evaluate them separately in Filter Transformations. Benefit: generated #sql query for INSERT will not have complex WHERE condition which UPDATE uses. #ETL #Teradata
- Gytis blog
- @gytis@blog.gyt.is
- More federation
- https://fediverse.dev
- Liberapay
- https://liberapay.com/gytis
ETL (Extract, Transform, Load), SQL (Structured Query Language), data modeling, databases and bits of big data. Microblog written by @gytis
Joined Jan 2019
