Page 1 of 1
parallel row splitter
Posted: Tue Jun 29, 2010 10:11 pm
by iskapalli
is there any row splitter stage in parallel jobs 8.1 like server?
Posted: Tue Jun 29, 2010 10:42 pm
by laknar
Yes it is.
Use Switch Stage or Filter Stage or Transformer Stage
Posted: Tue Jun 29, 2010 11:02 pm
by iskapalli
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.
Posted: Tue Jun 29, 2010 11:22 pm
by ray.wurlod
Transformer stage.
If the elements are of fixed size you can also use Modify stage.
Posted: Wed Jun 30, 2010 10:02 am
by laknar
If the Output is single row.Use Pivot Stage to split single Row into Multiple rows
Posted: Wed Jun 30, 2010 5:08 pm
by iskapalli
ray,the elements are not fixed size . Please sugget me
Posted: Wed Jun 30, 2010 7:03 pm
by ray.wurlod
Don't try to find a solution using Modify stage. Use Transformer stage.
Posted: Thu Jul 01, 2010 8:15 am
by rameshrr3
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...
Posted: Thu Jul 01, 2010 10:16 am
by eostic
Sounds like you might just be doing an alternate assignment of metadata....consider using ColumnImport.....
Ernie