Finding Record Count of tables in SAP Information Steward

[former_member680505]

Hi Team,

I was trying to discover is there a way in Information Steward to know how many records a table has without having to manually check the view data option? Are there are any quick ways to do this?

Example: Say I have a table in SQL Server connected to Information Steward and I wanted to find the record count within a table on the database?

Also, I am not sure if this is possible, but does Information Steward have the capability to compare tables that have about 50 Million records or is it recommended to use SAP Data Services?

Thanks

A

[Julian_Riegel · Accepted solution]

Hey there,

you can simply profile the table/view. After a profiling it gives you the rowcount of the table if you hover over the blue "I" next to the table name as shown below "Rows Processed: X":

Comparing huge tables should rather be done with DS - or you could reduce the content of the tables by building specific views in IS. If you actually need to compare 50 mio records from various tables it is recommended to do some preprocessing in DS to avoid huge rule-task runtimes - this depends on the complexity of the rules which are applied to those datasets though.

Regards,

Julian

[former_member680505]

Thanks Julian, Appreciate the fast reply.