parallel row splitter

iskapalli · Post by **iskapalli** » Tue Jun 29, 2010 10:11 pm

is there any row splitter stage in parallel jobs 8.1 like server?

laknar · Post by **laknar** » Tue Jun 29, 2010 10:42 pm

Yes it is.

Use Switch Stage or Filter Stage or Transformer Stage

iskapalli · Post by **iskapalli** » Tue Jun 29, 2010 11:02 pm

thanks lakner. I want to explain briefly my job design.

MQconnecterstage-> xml transfomer(XSLT)-> row splitter (server)-> teradata
example :
if source is haveing 3 messages after the XSLT we are getting three messages as one line. Because of this I used in row splitter stage (server).
it is doing correctly. Because of this we are faceing some problems.
Please let me know can we use any other stage instead of row splitter.
Please let me know if you need any details.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 29, 2010 11:22 pm

Transformer stage.

If the elements are of fixed size you can also use Modify stage.

laknar · Post by **laknar** » Wed Jun 30, 2010 10:02 am

If the Output is single row.Use Pivot Stage to split single Row into Multiple rows

iskapalli · Post by **iskapalli** » Wed Jun 30, 2010 5:08 pm

ray,the elements are not fixed size . Please sugget me

ray.wurlod · Post by **ray.wurlod** » Wed Jun 30, 2010 7:03 pm

Don't try to find a solution using Modify stage. Use Transformer stage.

rameshrr3 · Post by **rameshrr3** » Thu Jul 01, 2010 8:15 am

Well , split the messages using Transformer stage - with field function or any other logical way of splitting, also propagate key columns to the output and combine using Funnel stage - assuiming all output links have same number of columns...

eostic · Post by **eostic** » Thu Jul 01, 2010 10:16 am

Sounds like you might just be doing an alternate assignment of metadata....consider using ColumnImport.....

Ernie