Regarding logic

sandeepsreedhar · Post by **sandeepsreedhar** » Thu Apr 08, 2010 11:30 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Apr 08, 2010 11:46 pm

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

chulett · Post by **chulett** » Fri Apr 09, 2010 6:08 am

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

DSguru2B · Post by **DSguru2B** » Fri Apr 09, 2010 8:55 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Apr 09, 2010 6:07 pm

Hashed files ("UniVerse" tables) use WITHIN.

sandeepsreedhar · Post by **sandeepsreedhar** » Sun Apr 11, 2010 11:32 pm

Hi,

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

Regards,

Sandeep

sandeepsreedhar · Post by **sandeepsreedhar** » Mon Apr 12, 2010 11:40 pm

Hi Ray,

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

Regards,

Sandeep

ray.wurlod · Post by **ray.wurlod** » Tue Apr 13, 2010 2:48 am

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