Geeks Talk

Prepare for your Next Interview




Rejected rows

This is a discussion on Rejected rows within the Data Warehousing forums, part of the Databases category; How to deal with rejected rows? NOTE : [This question was asked by Sri]...


Go Back   Geeks Talk > Databases > Data Warehousing

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 01-05-2007
Expert Member
 
Join Date: Oct 2006
Posts: 690
Thanks: 0
Thanked 49 Times in 41 Posts
JobHelper is on a distinguished road
Rejected rows

How to deal with rejected rows?

NOTE : [This question was asked by Sri]
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 01-05-2007
Junior Member
 
Join Date: Dec 2006
Location: London
Posts: 20
Thanks: 0
Thanked 2 Times in 2 Posts
manisha.sinha is on a distinguished road
Re: Rejected rows

Write them in a separate target file. Ideally , there should be no database level rejects. Only at the router level , which you can send to a flat file.
Reply With Quote
  #3 (permalink)  
Old 05-12-2007
Junior Member
 
Join Date: May 2007
Location: india
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
rsrevathi is on a distinguished road
Re: Rejected rows

using reject load utility get the reject file as the source again and apply the business rules after cleansing.
Reply With Quote
  #4 (permalink)  
Old 05-14-2007
I am the DON
 
Join Date: Apr 2006
Location: Just on Earth with all....
Posts: 102
Thanks: 1
Thanked 32 Times in 25 Posts
sanghala is on a distinguished road
Post Re: Rejected rows

Quote:
Originally Posted by JobHelper View Post
How to deal with rejected rows?

NOTE : [This question was asked by Sri]
Can you please elaborate your question, that what type of your output that you need from the geeks...
__________________
Sanghala
www.dwforum.net - A Great resource for Data Warehousing Professionals

If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
Reply With Quote
Reply

  Geeks Talk > Databases > Data Warehousing


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Display n-1 rows from a table dbtester SQL Server 3 02-07-2008 08:11 AM
Geting data from odd rows of an excel sheet, JobHelper WinRunner 2 10-18-2007 07:17 AM


All times are GMT -4. The time now is 02:11 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved