Different metadata in source and target tables

DSRajesh · Post by **DSRajesh** » Fri May 08, 2009 6:12 am

Hi

I have two diff databases with source sql server and target oracle db
i have different metadata source and target tables in both the systems
when i ever i try to load columns in target table from oracle ,i ma losing the actual metadata from source table and replacing with target metadata.

how to i stop this to different metadata into the both systems

regards
rajesh

nagarjuna · Post by **nagarjuna** » Fri May 08, 2009 6:20 am

Put another stage ( transformer ) in between source and target then you can make conversions in transformer .

DSRajesh · Post by **DSRajesh** » Fri May 08, 2009 6:27 am

why do i put transformer?
here i am facing diferent issue not data conversion

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri May 08, 2009 6:54 am

Nagarjuna is correct. Try it and you will understand.

DSRajesh · Post by **DSRajesh** » Fri May 08, 2009 10:25 am

Hi Sai and Nag,

Thank you for the response.
I understood your concept of transformer in order to have different meta data in source and target as we can change the metadat in transformer if i am correctly understood.
But we can do the same usin modify where we can achieve the perforamance.

here if i have to take 200 coulmns in my target whose metadata is altogether from source metadata do i need to change for 200 columns?

or is there any alternative to directly have metadata for target itself?

ray.wurlod · Post by **ray.wurlod** » Sun May 10, 2009 4:45 pm

The column definition collection is a property of the LINK.

Does that help your understanding?