DSXchange

Hi,

we have a following requirement. We will be getting a source file which contains details of an EMPLOYEE ID and SUPERVISOR ID. We need to find out all the direct and indirect EMPLOYEE IDs under a particular SUPERVISOR. For example

Employee Supervisor

E1 S1
E2 S1
S1 S2

The employees under supervisor S2 should be E1,E2,S1.


Can anyone help me on this please

That's not an ETL task - it's a reporting task. Most reporting tools can perform this kind of query.

What database do you have at your disposal? Are you allowed to create temp/work tables in it?

For oracle you can use 'connect_by()', for db2 use the 'with' expression.

Hashed files ("UniVerse" tables) use WITHIN.

Hi,

Database used is DB2. Yeah we can create temporary tables,

Regards,

Sandeep

Hi Ray,

I cant get you.
Can we do this activity using datastage?

Regards,

Sandeep

For a small number of possible levels yes. But it's not what DataStage is intended to do.