

How can I generate the DMLs using this info. I have input files in fixed length format and the data dictionary is being Subject: Generate DML from Excel Data Dictionary From: eprince via abinitio-l [mailto: Friday, Ap6:35 AM Some hints - use read_file() to get the contents of the Excel Spreadsheet Stage, and generate the metadata within the graph that will read the actual

The advantage here is that you can miss the separate metadata building If you are familiar with the Normalize component then step 3,4 and 5 can beĪccomplished in side this component very easily (just add 2 to the length ofĪlternative approach once you have the transform working is to write in PDL. Write out (maybe extend to use WMF once everything is working fine) Transform the excel column metadata into Ab Initio equivalent

Read the excel data dictionary file( you could use RMF to read themĪll at once, but first things first, get the logic right)
#Excel data generator serial#
Generate DML out to a file or a variable.Ĭouple of options to accomplish this depending on how confident you feel.īuild a graph - (keep the flows serial as field order is important) You can build the DML using the transform functions and then write the
