Combine 2 input files into single output WITHOUT lookup?
What is the best practice to combine two differently structured input files into a single output file when there is no relationship between the two files? The tMap component can't have multiple input files, unless you are doing a lookup, which I am not. The tUnite component must have the same schema for both input files, which is not the case and I don't want the data to be split to multiple rows. When I add a RowNum column to both files and use tJoin component with Include lookup columns in output column mapping for Col4, Col5, Col6 and Key Definition RowNum Lookup key attribute row2.RowNum I get the desired results. Is there a better way to do this?
My job: tFileInputDelimited_1tJoin_1 tFileOutputDelimited_1 tFileInputDelimited_2