regarding rowsplitter

vijaykumar · Post by **vijaykumar** » Mon Dec 18, 2006 7:25 pm

hi gurus,
odbc--->transformer---->odbc---->rowsplitter--->2 odbcs

i wanted to analyze the property of rowsplitter.

i have joined 2 tables in the source stage, and stored in ODBC stage.
iam storing the join of 2 tables in ODBC for other purposes.
now can i use rowsplitter to get back my source tables.
for ex:i have joined employee and deptno i source stage and stored the result in odbc stage.
now can i use the rowsplitter to get 2 individual tables(NOT THE JOIN)
namely employee and dept.
plz help me .

cheers;
vijay

chulett · Post by **chulett** » Mon Dec 18, 2006 8:15 pm

No. Have you read the Help on what it actually does? It 'splits' an Input string (one big field) into Output columns (many smaller fields) and only supports one link in and one link out.

All you need are two links from a transformer to your '2 odbcs'.

kumar_s · Post by **kumar_s** » Mon Dec 18, 2006 8:51 pm

Hi Vijay,

As mentioned by Craig, you dont required this stage for your given need. Just pick up what ever column you need from the joined input.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 18, 2006 9:01 pm

It would be more efficient not to try to undo the join, but to select the original tables from the original tables.

Code: Select all

       ----->  Transformer  ----->  ODBC2   (original table A)
ODBC1  ----->  Transformer  ----->  ODBC3   (original table B)
       ----->  Transformer  ----->  ODBC4   (join of tables A and B)