You are not logged in.
I am facing this issue that i have input from multiple files & want to join those on the basis of one common U_ID.How to implement the join in tmap.PFA the screenshot which will bring much clarity on the type of data in input & output files & on the join condition.Also i want to have multiple delimiters on the basis of one U_ID.For eg- in the output file multiple Column values will be separated by “||” and multiple row will be separated by “~~” as given in the screenshot.Please help asap guys as i am stuck very badly.
One way of achieving this is by using tMap and tDenormalize combination.
We will have three sub jobs one to read each input file. Each sub job will denormalize the corresponding input. The output of each sub job will appended to the same intermediate output file. (In the screen shot tFileOutputDelimited_1, tFileOutputDelimited_3 and tFileOutputDelimited_4 refers to the same file with the schema U_ID;SCode_SName;JCode_JName;QCode_QName).
Once the three input files are denormalized, we can aggregate the intermediate output file grouping by U_ID and taking MAX of SCode_SName, JCode_JName and QCode_QName columns to generate the required final output.