Lookup Table Challenge and Job Status

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
srinivasb
Participant
Posts: 42
Joined: Mon Mar 10, 2003 10:52 pm
Location: UK
Contact:

Lookup Table Challenge and Job Status

Post by srinivasb »

Hi,

We have a issue to be solved which we are working on against a very tight deadline:Usage of Composite primary Key as Look up:

Example: There is a parent table with primary key PID and Parentname

There is a child table with a composite primary PID and CID and Childname.


For every PID , there are mulitple PIDCID combinations

For example :

Parent Table
PID Parent Name
ABC,John Sr
XYZ,Ron

Child Table:

PIDCID Child Name
ABC001,John1 Jr
ABC002,John2 Jr
ABC003,Christie
XYZ001,Ron1 Jr

we have to use the child table as look up(reference) and write all values into a target table with parent table being looked up.

As you are aware, this requires a portion of the composite key to be matched with PID.

Please help out.

Storage of job logs/status into a table:

we require logs to be written onto a table directly, so I require your inputs if any one has done this .

Many thanks and best regards
Srinivas.B
Cell 00971507380893
bsrinivasan_10@hotmail.com

Srinivas.B
Dubai
Mobile :00971507380893
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

The Parent list will be your reference lookup, the Child list will be your source data. Inside the transform drag the PIDCID field onto the parent PID field. Modify this field to read "Left(PIDCID, 3)" to ensure you only match the first three characters. Now drag across the required output fields.
Post Reply