Split Input Records using Round Robin - Datastage Tutorial

Publicado em: 07 Dezembro 2018
no canal de: Datastage Tutorial

3,030

Task: You have a sequential file with some line of structured records. Design a Datastage job to Split the file into two files. One file should contain 1st line,3rd line,5th line and so on. Second file should contain 2nd line, 4th line,6th line and so on.

Solution:
Using Round Robin partitioning, we can easily achieve the desired result. In Round Robin partitioning, the datastage sends the first record of the input file to the first processing node, the second to the second processing node, and so on. When the last processing node in the system is reached, the process starts over.

We need to create a datastage job and configure its properties to run in two nodes using the configuration file. Use Transformer stage to divide the input file into two output files. Set the partitioning method as Round Robin. Use system variable “@PARTITIONNUM” in the transformer constraints to filter the records based on the nodes from which the records need to be collected and written into the respective output files.

Nesta página do site você pode assistir ao vídeo on-line Split Input Records using Round Robin - Datastage Tutorial duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Datastage Tutorial 07 Dezembro 2018, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 3,030 vezes e gostou 11 espectadores. Boa visualização!

151

00:00:00