Exforsys

Free Training

Hi

This is a discussion on Hi within the Data Warehousing forums, part of the ERP category; Hello Can anyone say is there any possibility to have duplicate rows while coming inside mapping.Since they all are cleansed ...

Go Back   Exforsys > ERP > Data Warehousing

Exforsys.com

  #1 (permalink)  
Old 12-28-2006, 08:35 AM
Junior Member
 
Join Date: Dec 2006
Posts: 2
srivaidekhi is on a distinguished road
Hi

Hello
Can anyone say is there any possibility to have duplicate rows while coming inside mapping.Since they all are cleansed through Cleansing tools when it comes to ODS it filters,then how it is possible,if so could anyone explain it with real time example.Thank u
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 12-28-2006, 08:37 AM
Junior Member
 
Join Date: Dec 2006
Posts: 2
srivaidekhi is on a distinguished road
Hi

--------------------------------------------------------------------------------

Hello
Can anyone say is there any possibility to have duplicate rows while coming inside mapping.Since they all are cleansed through Cleansing tools when it comes to ODS it filters,then how it is possible,if so could anyone explain it with real time example.Thank u


srivaidekhi
View Public Profile
Send a private message to srivaidekhi
Find all posts by srivaidekhi
Add srivaidekhi to Your Buddy List
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 01-31-2007, 02:12 PM
Member
 
Join Date: May 2006
Posts: 38
zsk_00 is on a distinguished road
take the duplicate row from target table and check back the same row in the source table to see if you have duplicates.

If you are joining the source table with another table in the source qualifier, you might get duplicate rows if the join is not complete or not done properly.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 06:04 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0
Copyright 2004 - 2009 Exforsys Inc. All rights reserved.