Handling Rejected rows to Exception table(created through designer)

Get new comments by email
You can cancel email alerts at anytime.
Comments (5)

sravu in Bangalore, India

81 months ago

Hi,

How can we handle or load the rejected rows to exception table.
In the Task,i have filtered the rows in SQ & used Exp,next joiner,Exp & finnaly to target.

So,from which point i need to start collecting all the rejected rows...

can anybody help me with this concept of Exception Handling

- Was this comment helpful? Yes / No Reply - Report abuse

Moin in Cleveland, Ohio

80 months ago

sravu in Bangalore, India said: Hi,

How can we handle or load the rejected rows to exception table.
In the Task,i have filtered the rows in SQ & used Exp,next joiner,Exp & finnaly to target.

So,from which point i need to start collecting all the rejected rows...

can anybody help me with this concept of Exception Handling

Hi,

Use a Router transformation and route all the unwanted data through a default port and then place exception table and load data into it.

Thanks

- Was this comment helpful? Yes / No (3) Reply - Report abuse

Mahesh in Bangalore, India

79 months ago

HI,
to handle the rejecting of records we use LOOK UP Transformation and we use DD_REJECT variable while configuring the transformation.

If you want to send the Rejected Records in to the Exception table then you need to use ROUTER TRANSFORMATION and from this transformation you can collect the rejected records then load in to the target table according to your requirement

I hope this will help full to you

Thank You

- Was this comment helpful? Yes / No Reply - Report abuse

naga in Framingham, Massachusetts

76 months ago

how we can load rejected rows from rejectlog file.

pls anybody helpme
Thanks

- Was this comment helpful? Yes (1) / No Reply - Report abuse

kumar in Toronto, Ontario

69 months ago

Mahesh in Bangalore, India said: HI,
to handle the rejecting of records we use LOOK UP Transformation and we use DD_REJECT variable while configuring the transformation.

If you want to send the Rejected Records in to the Exception table then you need to use ROUTER TRANSFORMATION and from this transformation you can collect the rejected records then load in to the target table according to your requirement

I hope this will help full to you

Thank You

Hi, Can you elaborate on how to capture (in mapping ) the rejected row ( source row) in error table.
Thanks
Kumar

- Was this comment helpful? Yes / No Reply - Report abuse

» Sign in or create an account to comment on this topic.