RowMerger

[Rajendran]

Hi,

In Row merger stage, when i am using Multiple lines option getting some errors.

Data was tranferd,but when open the View data showing some formet.
I could't able to understand.

Pls let me know,
1) What is the purpose..
2) How can i use some example?
3) Tell me situations where will use??

By,
RAJa

[rasi]

Hi Raja

View the datastage help about Row Merger. Below is the first few lines extract from the help.

The Purpose :

"The row merger stage reads data one row at a time from an input link. It merges all the columns into a single string of a specified format. It then writes the string on a given column of the output link. The stage can have a single input link and a single output link."

Where will it be used :

When you want to concatenate columns to one single string this is helpful.

Thanks
Siva

[suma]

I understand the Basic conceptof Row merger,But still I think
we have an option for multiple lines,that decides if the output
contains one row or multiple rows.But i am not sure with how that works.
I tried using that and i face some problem.Can any explain me about this concept??

And I have one more doubt like if i am using 000 as the Delimiter and
again 000 to quote character.In the Row merger I will get a concatenated output
like "col1valuecol2valuecol3value", Then how can i split them using
row splitter. Should i go for Fixed Width columns in that case?

SumA

[vmcburney]

SumA, the "Multiple Lines" checkbox will switch the stage from a column merge action to a column and row merge action. When it is checked all rows are combined into a single text string and written to the target without end of line markers.

If you turn on the check box then your output will be very difficult to view via the "View Data" button as it wont make much sense.

I use the row merge stage to merge or concatenate columns and I have never used it to merge rows.