Page 1 of 1

can i generate reports

Posted: Tue Jun 23, 2009 8:00 am
by sunitha_cts
Hi,

I want to keep track of the rejected records at the source which is called quality reports and error reports which are generted by using transformation ,the rejected records at the transformation .So Can all the reject records be maintained in these two report files ,if yes how could it be done.
Thanks
sunitha

Posted: Tue Jun 23, 2009 8:11 am
by Sainath.Srinivasan
Where do you get these questions ?

Posted: Tue Jun 23, 2009 8:38 am
by sunitha_cts
Hi,

I don't have special books to follow ,these r my client's reqiremnt when using large volume of data

Posted: Tue Jun 23, 2009 8:46 am
by nagarjuna
use reject links at source and at the transformer .This way you can capture the bad & rejected data .

Posted: Tue Jun 23, 2009 9:10 am
by chulett
Right... use links from the transformers to capture both logical and/or physical rejects and then transform/land them after that any which way you like.

By 'logical' I mean records you reject before the target using constraints, 'physical' would be ones the target rejected and barfed back up. Be aware that the latter will typically abort your job so are best to avoid (or handle logically) if at all possible.