Can u have a look into this issue ....

[ProDev]

Guys,


Here is the scenario.


Source : Flat file
Target : Oracle table

Transformations : Expression, Router, Maplete, LookUp,Expression, Router, Update Strategies.

Basic functionality : Find out good and bad records and then do Insert if thats a new record, otherwise do an update to target.

Problem : I have an aggregator transformation linked to the Source Qualifier. Purpose is to do a COUNT(*) and find out the no of records read.
But this aggregator is giving a count < total records loaded to target. How is this possible ??


Thanks

 

[Sridharan]

With the given information I would suggest you to look into the Router condition. Are they mutually exclusive??? It is possible that the two routers that you are using look at the condition the other way and hence might be routing the data twice. I think you can achieve your results without Router which case you will be having two aliases of your Target which is unwanted with the given B Rule .


Sri

 

[cyno]

r u specifying group by clause while using aggregator.Without group by u cant get the count.