Skip to Content
author's profile photo Former Member
Former Member

Problem during the update of Data from 2 ODS into 1 ODS

Hi Guru's ,

Please help me in resolving the issue below.

I have 2 ODS , ODS1 and ODS2

with same key field as 'A' but diffrent data feilds.I want to merge the records from ODS1 and ODS2 into ODS3 with the same key as 'A'.

When I load from ODS1 all the fields are populating but when I load ODS2 the monitor says everything is OK and say x number of records got transfered. But when I check the ODS3 table , all the feilds coming from ODS2 are blank.

What should be the reson behind this?

Please help.

Thanks in Advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 09:47 PM

    I am taking the question Back. 😊

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.