Fetch Column derivation for all Active stages

jayanthkaliappan · Post by **jayanthkaliappan** » Tue Feb 17, 2009 6:02 am

Im reiterating the problem we have faced when fetching metadata from active to passive stage.

Call DSGetLinkMetaData(Result,JobName,stgname,stglinkname)
WriteSeq "the deriavtion is:":Result<9,k> To FileVar
Stg1------>Transformer1----->Transformer2-------->Stg2
There are three links link1, link2 and link3.
I can able to fetch link2 columns and its derivation from Transfomer1 usingDSGetLinkMetaData.
For Transformer2 i am unable to fetch the columns and its derivation for link3.
If we need to get the columns of link3, we can fetch it from Stg2.
However i need to fetch column and its derivation for all transformer.
Please help me in getting the derivations for Transformer2.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 2:26 pm

How many columns are actually defined on that link?

jayanthkaliappan · Post by **jayanthkaliappan** » Wed Feb 18, 2009 2:27 am

nearly upto 40 columns are there in that link? Please advice.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 18, 2009 4:29 am

How many fields are actually returned in the dynamic array?

Code: Select all

DCount(Result,@FM)

What's happening in the eighth field? You talk about the first seven, then the ninth? I'm wondering why.

What is the source of the column definitions on this link? Hashed file or some other source that uses positional addressing rather than name-based addressing?

jayanthkaliappan · Post by **jayanthkaliappan** » Thu Feb 19, 2009 12:45 am

ray.wurlod wrote:How many fields are actually returned in the dynamic array?
Code: Select all
DCount(Result,@FM)
What's happening in the eighth field? You talk about the first seven, then the ninth? I'm wond ...

"The column derivation has been retireved for the first transformer which has single output link. In the second transformer the output has two links. The two output links column derivation returns empty."

ray.wurlod · Post by **ray.wurlod** » Thu Feb 19, 2009 1:23 am

That statement does not address any of my questions.

How many fields are in the Result dynamic array?

I'd also like answers to my other questions, but you will need premium membership to read those.

Do you have ANY idea what you are doing?