can i generate reports

sunitha_cts · Post by **sunitha_cts** » Tue Jun 23, 2009 8:00 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jun 23, 2009 8:11 am

Where do you get these questions ?

sunitha_cts · Post by **sunitha_cts** » Tue Jun 23, 2009 8:38 am

Hi,

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

nagarjuna · Post by **nagarjuna** » Tue Jun 23, 2009 8:46 am

use reject links at source and at the transformer .This way you can capture the bad & rejected data .

chulett · Post by **chulett** » Tue Jun 23, 2009 9:10 am

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.