Use the tNormalize column to break a multi-valued attribute stored in an RDMBS column into individual rows. This is great for a second pass on an input file to fill up a join.
This tutorial shows how to take a record containing a multi-valued attribute (like "SWI,CON,TEN") and write out a record for each value (a record for "SWI", a record for "CON", a record for "TEN").
Talend Open Studio has a great component for this called tNormalize.
This tutorial shows how to take a record containing a multi-valued attribute (like "SWI,CON,TEN") and write out a record for each value (a record for "SWI", a record for "CON", a record for "TEN").
Talend Open Studio has a great component for this called tNormalize.
http://www.youtube.com/watch?feature=player_embedded&v=Urt13MQHZaQ#t=0s
No comments:
Post a Comment