i have no idea why the data types will be changing so often

I was told to do so by my boss.

He just explained me waht to do but didn't say...

i should use a stored procedure cause it will be used very often

That is the task given to me.

I understood some things in that like

I have to create a stored procedure that converts those data types.

BUt i didn't get how can a...

Thanks for the replies

I will try it out

Thanks for that forum man.

yes it is oracle DB

Can anyone help me with this?

I am not sure as i am new to both.

I think it is oracle.

If you know can you help me?

Ok i got it

so identity values will be taken by default, then that is fine.

Thank You

Hey i just confirmed with my boss and he said that it is right.

But do you remember about identity columns.i.e col1

We have 4 values in common in source and target...

Ok man I got what you said.

So if we delete a value in a table will it by default set value as NULL.

I have to clarify somethings with my boss...

So according to the spec i gave do you think that i have to write a code for deletion of columns?

I am using SQL SERVER 2005.

Can we write a DDL...

This may be auditing, but i dont have an idea bout auditing since i am new to sql.

They want to delete the entire column it seems.

What makes the difference if...

But once in a meeting they said that they are going to delete certain columns like address line2, addressline 3.

Those values should be inserted in to Schema2.DIMCNAM.

That is what i...

I edited my above reply

Please see the specification given to me.

I wrote exactly what it says in my specification.

I dont think u r difficult.

Actually problem is with me...

Even i dont know about my goal here exactly. I am very much confused.

I have to ask my boss again and make some clarifications.

In the technical Spec they gave like...