Nowadays, we are living in an open and connected world, where small, medium and large companies are looking for better data analysis. The data warehouses DW) is an example of these systems, which have recently experienced a drop in speed with the appearance of massive data and their different V (Volume, Variety, Velocity, Value, etc.). The advent of the Linked Open Data era (LOD) is a great opportunity for DW, because they add value. Taking this Value into account in the design of DW has to deal with the problem of the Variety of data sources and the Variety of the target storage formats of the DW. In this paper, we present a new DW value and variety driven design approach, where different integration scenarios of LOD impacting ETL processes are investigated. Finally, we expose experiments validating our proposals.