I was trying to do some fancy stuff in response to a query posted on this forum.
The issue was to split a string
Code: Select all
Id, String
1, "a,b,c,d,e,f"
Code: Select all
Id Value
1 a
1 b
1 c
1 d
1 e
1 f
I tried to design a Job
Code: Select all
srcFile -----> Full Outer Join ----> Transformer -----> Output
^ |
| |
| v
------------------ Filter
The rest of the "string" is passed thru a filter (to see if it is empty) and joined with the source.
Theoritically & Programatically this type of looping should work fine, but for some reason Datastage does not seem to like this.
When I run the job, I get the error..
Code: Select all
main_program: Data flow cycle detected among operators in step
Regards