Table Comparison

[Former Member]

Good afternoon,

I am trying to compare two tables but appears to being doing something wrong. When i try to map the output of the table comparison I keep getting the error

This object <Query_1> requires input rowtypes: [Normal]. But it is recieving only row types :[Insert].

Can anybody provide some clarification.. I assume I'm doing something dumb.

Thanks,

ian

[Former Member]

Dear Ian,

Could you help us understand your issue better. Is this something related to BEx or relative to Crystal Reports? Comparing, doing VLOOKUP operations etc is not a basic operations we can find in BEx tools today. But using TCODE RSANWB, you can check out APD for the multiple features to transform/classify data & make it meaningful. As you had requested you can then add your Query as your data source(s) also & export these modifs to a intermediate DSO etc & try reporting on this.

Best Regards, @{

[Former Member]

I am comparing Informix tables to Oracle to validate that a data migration has been successful.

Source table being Informix, performing a query transform to "cleanse" data . Then I run the table comparison against the two tables to validate that the migration is successful.

Am looking to create counts for records that have been updated, deleted and inserted during the process. I know that I can use the output of the table comparison using mapping transform to take this output then combine this output so can be placed into a target table for quick evaluation.

Nothing that complex here - The Data Services Table comparison transform does the work and I have used this methodology in past. Just running into the issue of the query expecting input and is getting either insert, update or delete.

One thing to note, the tables have really no unique key so I concatenated some fields together to produce a unique key from which to compare the data sets.

Any input would be appreciated,

Thanks,

Ian

Edited by: Ian Scott on Feb 8, 2012 1:53 AM

[Former Member]

Hello

Typically the output of the table comparison is sent to a history preservation or a table loader as these can both take inserts, updates and deletes. In your case, you need send the output to a query to perform the counts. This is easily achieved by dropping 3 map operation transforms into your dataflow, taking the output from the table comparison into each one. In one map operation map inserts to normal,and discard everything else, in the second map updates to normal and discard everything else, etc.

The output from each map operation can then be sent to a query.

Michael

[Former Member]

Michael,

Thanks for your response. That was exactly what I was doing. Found out that my issue was when I was adding map operation individually to the screen. if I placed transforms sequentially and modified a statement for "insert", then added another map transform to the screen for "update" I would get the error below

"This object <Query_1> requires input rowtypes: Normal. But it is recieving only row types :Insert. "

If I placed three map transforms on the screen at once then joined them with the table comparison and then drilled into them to do as you suggested then I wouldn't get the above error. Somewhat bizarre but I am now in business. Appreciate the assistance.

Ian

[Former Member]

You cannot map a table comparison to Query. You need table.

Arun

[Former Member]

Yes I understand that, my table comparison has two tables, it is the output of this that I would then like to join to a query for further modification.