Parent in hierarchy

dssubhani · Post by **dssubhani** » Thu Jan 13, 2011 7:25 pm

hi,
i have parent in hierarchy having 2 childs.....this chain continues upto 25 th level..one company is on 9 th level,8th level is parent of 9th,7th to 8th....like....1st to 2nd...........now how can i track the records?what is the logic used in stage?

thanks in advance..........waiting for reply...........

subhani

ray.wurlod · Post by **ray.wurlod** » Thu Jan 13, 2011 8:09 pm

Server job (as posted) or parallel job (as marked)? Are you seeking to construct this hierarchy or to read from it?

dssubhani · Post by **dssubhani** » Mon Jan 17, 2011 1:34 am

just read from it?how?

ray.wurlod · Post by **ray.wurlod** » Mon Jan 17, 2011 5:27 am

Using what kind of job? This is important - it's done in different way in different job types.

dssubhani · Post by **dssubhani** » Sun Jan 23, 2011 6:27 pm

ray.wurlod wrote:Using what kind of job? This is important - it's done in different way in different job types. ...

....IN PARALLEL JOB

ray.wurlod · Post by **ray.wurlod** » Sun Jan 23, 2011 11:42 pm

If your source is a database table, you can use a recursive SELECT statement. Some database servers have specific syntax for this, in others you may need to script it.

There's nothing within parallel job stage types for undertaking this kind of query, unless you'd like to string together 24 Join stages all referring to the same table.

DSXchange

Parent in hierarchy

Parent in hierarchy

thnks

PARALLEL JON