Shulou(Shulou.com)06/01 Report--

This article mainly introduces "the use of denormalizer in kettle". In the daily operation, I believe that many people have doubts about the use of denormalizer in kettle. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "the use of denormalizer in kettle". Next, please follow the editor to study!

There are two kinds of data that need to change rows: with primary key and without primary key, first without primary key

Transfer to the previous content

Transfer to the future content

See? it's turned around. Okay, let's get an overall flow chart.

Start the analysis:

When the first icon is opened,

This is the main step in the first step, and once it is configured here, you can proceed to the second step.

Because there is no primary key, we need to add the same primary key to the city column, so that the data can be transferred to the same row when the data is converted to a row. If the primary key is different, after the primary key is converted to a row, each primary key is a row, which is not what we want.

Open the interface for column row conversion as follows

The dummy in the figure is the constant we added in the previous step. Select the city in the key field, the value of the city in the key field, and the key of the number of people in the data field. The so-called target field is the name you want to see after converting to a row.

Open the result output icon

All right, this is all configured. Click the execute button and you will see the results at the beginning of the article.

Don't say that if you have a primary key, which is simpler than those without a primary key, because the data with a primary key can be transferred directly.

At this point, the study of "how to use denormalizer in kettle" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.