Need a little help on Hierarchy Load

[prasoon92]

I need to create hierarchy of Predecessor and Successor jobs using (Predecessor_ID, Successor_id, Predecessor_name, Successor_name).

but, the problem is I have Predecessor_id values in Successor_id field.

None of the Predecessor is Null and there are so many field where Predecessor and Successor id is same.

for example:

Two of the rows in the tables

Predecessor_ID Successor_id Predecessor_name Successor_name    mapping_control

55001                  55001              Extract                           Extract                     1

55001                  42569              Extract                           refresh                     2

42563  55001           refresh                        Extract                  3

42563                   22105              refresh                          Transform                4

55001                  55001              Extract                            Extract                     5

Has anybody come across such scenario?