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
regarding rowsplitter
Moderators: chulett, rschirm, roy
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'.
All you need are two links from a transformer to your '2 odbcs'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.