srinivas vadlakonda

• Oct 24th, 2006

 

After creating the mapping we can execute the session for that mapping after that we can use the unit testing to test data. And we can use the oracle to test how many records are loaded into the  target, that loaded records are correct or not for this purposes we can use the oracle or Toad.

sn3508

 Profile Answers by sn3508 

• Oct 26th, 2006

 

TOAD is a user friendly interface for relational databases like Oracle, Sql Server, DB2.  While unit testing the development or query on tables, one can use TOAD with basic  knowledge on database commands.

pushpam

 Profile Answers by pushpam 

• Nov 3rd, 2006

 

Toad is a application development tool built around an advanced SQL and PL/SQL editor. Using Toad, you can build and test PL/SQL packages, procedures, triggers, and functions. You can create and edit database tables, views, indexes, constraints, and users. The Schema Browser and Project Manager provides quick access to database objects.

Toad’s SQL Editor provides an easy and efficient way to write and test scripts and queries, and its powerful data grids provide an easy way to view and edit Oracle data.

With Toad you can:

• View the Oracle Dictionary
• Create, browse, or alter objects
• Graphically build, execute, and tune queries
• Edit PL/SQL and profile stored procedures
• Manage your common DB tasks from one central window
• Find and fix database problems with constraints, triggers, extents, indexes,and grants
• Create code from shortcuts and templates
• Create custom code templates
• Control code access and development (with or without a third party version control product) using Toad's cooperative source control feature.