Test Case for ODBC table update : Scenarion

smrutiranjannayak · Post by **smrutiranjannayak** » Sat Apr 21, 2007 6:08 am

I have the following scenario :

Sequential file 1.....> .................> ODBC (update table)
Transformer
ODBC stage....> .................> ODBC (update table)

I need to use a file and database(reference) as input and i need to update( or create two tables ) .

Please suggest me what are the possible test cases ?

Means what can be the possible check points for error handling ?
What a developer and tester should look for such a scenario .

ray.wurlod · Post by **ray.wurlod** » Sat Apr 21, 2007 3:32 pm

Values that should be looked up successfully.

Values that should fail to be looked up successfully (your job design appears simply to drop these - how will you reconcile row counts?).

Null values in column(s) in the stream input used in the reference key expression.

Rows that violate constraints in the target table.