Link Derivation

[sathishmca]

How to get the derviation of all links in a job ?

[ray.wurlod]

Open the job in Designer and inspect them.

[PhilHibbs]

How to get the derviation of all links in a job ?

Export the job to a DSX, and search for "Derivation". If you have Perl installed:

Code: Select all

perl -ne "$lk=$_ if /^      Name/;$f=$_ if /^         Name/;print $lk.$f.$_ if /^ +Derivation/;" filename.dsx

This will print out the link name, field name, and derivation for every output field in the job.

Slightly more sophisticated, includes job name, removes repetition:

Code: Select all

perl -ne "$j=$_ if /^   Identifier/;$lk=$_ if /^      Name/;$f=$_ if /^         Name/;if (/^ +Derivation/){print $j.$lk.$f.$_;$j=$lk=''}" jobname.dsx

[chulett]

Or push the button in the Designer that looks like the IE icon, it will generate an HTML document with everything in the job.

[PhilHibbs]

pfff, where's the fun in that?

[chulett]

Yah, yah Mr Henry... give me Perl or give me death.

[gateleys]

How to get the derviation of all links in a job ?

Export the job to a DSX, and search for "Derivation". If you have Perl installed:

Code: Select all

perl -ne "$lk=$_ if /^      Name/;$f=$_ if /^         Name/;print $lk.$f.$_ if /^ +Derivation/;" filename.dsx

This will print out the link name, field name, and derivation for every output field in the job.

Slightly more sophisticated, includes job name, removes repetition:

Code: Select all

perl -ne "$j=$_ if /^   Identifier/;$lk=$_ if /^      Name/;$f=$_ if /^         Name/;if (/^ +Derivation/){print $j.$lk.$f.$_;$j=$lk=''}" jobname.dsx

Hey Phil (or any Perl Gurus here),

Can you change the second Perl script so that it returns the JobName (StageName if possible) that contains the string that I want to search for? The search string may be part of the SQL in an ORAOCI stage, Xfmr derivation or even in an Annotation.

Thank you.