null transformer and outer join
Redis cache