Lanciaux Maxime | BI | DWH | Hadoop | DevOps | Google Cloud | DataOps | PostgreSQL

PostgreSQL, BI, DWH, Hadoop, DevOps, DataOps, Machine Learning, Cloud and others topics !

Labels

Administration Analytics Architecture Aster Automation Best practice BI Bitcoin Bug Business Intelligence CDO Data visualization Databases DataFlow DataLake DataMesh DataOps Datawarehouse Detente development DevOps ElasticSearch enterpr1se 3.0 ETL Flume Fun Games Git Google Cloud Platform Graph Database Hadoop Hadoop 2.0 Hbase Hive Impala Informatica IoT Java Javascript Jazz Jenkins Kafka linux Machine Learning Mahout MapReduce Meta Development Monitoring Mood Music Oozie Optimisation performance Pig Python Quality R Real Time Scala scam Shark SolR Spark SQL Standards Statistics Stinger Storm SVN Talend Task TED Teradata Thinking Ubuntu Useful Web development WTF Yarn Zeppelin Zookeeper

Thursday, July 31, 2014

Partial Redistribution Partial Duplication

PRPD is a new feature in Teradata since 14.10 and it improves joining with skew tables (so it depends on statictics to identify skewed values). This is a smart way to avoid DBA to create Surrogate key !
Labels: Optimisation, SQL, Teradata, Useful

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)
Simple theme. Powered by Blogger.