regarding transformer stage

vijaykumar · Post by **vijaykumar** » Thu Dec 14, 2006 1:52 pm

hi,
my source is sql server
target is sql server.
my design is
iam using DRS stage to connect to SQL server and a transformer stage to perform transformations, and DRS stage as target.
i created another link from the transformer stage to sequential file inorder to catch the rejected rows.

i specified a constraint in the transformer stage,when specifying constraint properties.
i declared as
dslink4- dslink3.city='Berlin'
dslink6- dslink4.Rejectedcode
for specifying DSLINK4 as rejected row, i have checked that link.
here DSLINK4 AND DSLINK6 ARE OUTPUT LINKS AND DSLINK3 IS INPUT LINK.
i want to specify DSLINK4 as rejected link.
iam getting error in the transformer stage.
plz help me.

cheers;
vijay

DSguru2B · Post by **DSguru2B** » Thu Dec 14, 2006 1:57 pm

You never mentioned what error message are you getting.
Change DSLink6 constraint to.

Code: Select all

dslink6- dslink4.REJECTED

You will also have to specify transaction size of 1 for this functionality to work properly. And there is a performance price to pay.
Uncheck the Reject box.

thebird · Post by **thebird** » Thu Dec 14, 2006 2:01 pm

If you want to specify DSLink 4 as the reject then give the constraint
dslink3.city='Berlin' against DSLink 6 and check the Reject Row check box for DSLink4.

What error are you getting?

us1aslam1us · Post by **us1aslam1us** » Thu Dec 14, 2006 2:01 pm

Hi Vijay,

What is the error message you are getting?

Sam

ray.wurlod · Post by **ray.wurlod** » Thu Dec 14, 2006 2:20 pm

It is impossible to help you without knowing exactly what error message you are getting. Otherwise your question is like "my car won't start - what's wrong with it?".

vijaykumar · Post by **vijaykumar** » Thu Dec 14, 2006 2:21 pm

hi Gurus,
i have connected DSLINK4 to DRS STAGE AND DSLINK6 TO SEQUENTIAL FILE.
i want all the rejected rows to go to SEQUENTIAL FILE.
i specified constraint for this.

linkname constraint rejected row abort after rows

DSLINK4 DSLINK6.REJECTED 0

DSLINK6 DSLINK3.CITY='Berlin' checked 0

here DSLINK3 is the input link.

iam getting error as ERROR PROCESSING TRANSFORM DERIVATION FOR TRANSFORMER STAGE.
plz help me.

cheers;
vijay

DSguru2B · Post by **DSguru2B** » Thu Dec 14, 2006 2:25 pm

Your explanation does not make sense.
You said

i have connected DSLINK4 to DRS STAGE AND DSLINK6 TO SEQUENTIAL FILE

SO that means DSLINK6 is the reject link.
But you say

DSLINK4 DSLINK6.REJECTED 0

DSLINK6 DSLINK3.CITY='Berlin' checked 0

The link that is going to the DRS stage is used in the reject link's contraint as follows

Code: Select all

LinkToDRS.REJECTED

vijaykumar · Post by **vijaykumar** » Thu Dec 14, 2006 2:44 pm

hi,

Thanks very much.
once again thanks.

cheers;
vijay