nagakalyan

 Profile Answers by nagakalyan Questions by nagakalyan

• Jun 19th, 2008

 

if u know that row we can call through stage proprtties we can go for @outrown num,if not u can go to tail stage if u now particular no

tina123

 Profile Answers by tina123 

• Jul 10th, 2008

 

Develop a job source seq file--> Transformer--> output stage

In the transformer write a stage variable as rowcount with the following derivation
Goto DSfunctions click on DSGetLinkInfo..
you will get "DSGetLinkInfo(DSJ.ME,%Arg2%,%Arg3%,%Arg4%)"
 Arg 2 is your source stage name
Arg 3 is your source link name
Arg 4 --> Click DS Constant and select DSJ.LINKROWCOUNT.
Now ur derivation is
"DSGetLinkInfo(DSJ.ME,"source","link", DSJ.LINKROWCOUNT)"

Create a constraint as @INROWNUM =rowcount
and map the required column to output link.

Akil

• Apr 1st, 2013

 

There are 2 ways to fetch the last row of any file if the number of records in the file is not known before run time:

1) Use the tail stage and run the tail stage in sequential mode
2) Use the lastrow() function in the transformer stage

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

 

There are multiple ways to do this, given that input is a sequential file. Two of them are

1. Use "Filter" option available in Seq file stage. Specify a unix command like: tail -1 (recommended)

2. Use a tail stage next to Seq filestage and then specify.