Split Input Records using Round Robin - Datastage Tutorial
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.
Sur cette page du site, vous pouvez voir la vidéo en ligne Split Input Records using Round Robin - Datastage Tutorial durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Datastage Tutorial 07 décembre 2018, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 3,030 fois et il a aimé 11 téléspectateurs. Bon visionnage!
