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
Different metadata in source and target tables
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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?
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?
RD
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: