sivag (7/23/2012)
plz tel me what are the requirement u need from me
We have been telling you what we need. we the DDL (the CREATE TABLE statements) for you source and destination tables. We need some form of diagram that maps all the columns from the source table to the appropriate columns in the destination tables. With the mapping, we need to know of any transformations, calculations, etc that must be done as the data moves from source to destination.
We need sample data in the form of INSERT INTO statements for the source table. We need to know what the expected results in each of the destination tables will be based on the sample data provided for the source table. Preferrably, the expected results should be provided as INSERT INTO statements such that they can be inserted into copies of the destintation tables to make comparisions between actual and expected easier.
Now, based on the above information, what don't you understand regarding what we are asking you to provide?