Results 1 to 6 of 6

Thread: Using Rejected Rows

  1. #1
    Geek_Guest
    Guest

    Using Rejected Rows

    My mapping is like this: source(emp), sq, filter transformation & target.The filter condition is deptno=10.
    In this deptno 20 & 30 will be rejected.
    Can I use these rejected rows in the same mapping?
    If yes, What is the way?

    Question asked by visitor peraiah


  2. #2
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Re: Using Rejected Rows

    You can't use filtered records in mapping. If you want to use them in further transformation then use Router instead of Filter.

    ...Thx

    Thx
    SRIRAM N
    Hope Everything Good

  3. #3
    I am the DON
    Join Date
    Apr 2006
    Answers
    99

    Post Re: Using Rejected Rows

    Quote Originally Posted by Geek_Guest View Post
    My mapping is like this: source(emp), sq, filter transformation & target.The filter condition is deptno=10.
    In this deptno 20 & 30 will be rejected.
    Can I use these rejected rows in the same mapping?
    If yes, What is the way?

    Question asked by visitor peraiah
    @peraiah -

    You can't get the rejected rows after filering out them by susing the Filter Transformation.

    One of the difference between the Filter and Router -
    YOu can divert the unmatched record to the default group by using Router where as in filter, you are unable to get the rejected (unmatched ) records, as the filter will not divert them to rejected/Bad file.

    As sriram told go for ROUTER to fulfill your requirement.

    Hope this provided the adequate info.



    Sanghala

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

  4. #4
    Junior Member
    Join Date
    Jan 2008
    Answers
    5

    Re: Using Rejected Rows

    using Bad file you can,try


  5. #5
    Junior Member
    Join Date
    Apr 2011
    Answers
    2

    Re: Using Rejected Rows

    Hi,
    In the filter trans we can just give single condition and we cannot find the rejected records , for u r query it’s better to workout in router trans u may clarify u r doubt.

    Last edited by admin; 04-15-2011 at 12:55 PM.

  6. #6
    Junior Member
    Join Date
    Aug 2011
    Answers
    18

    Re: Using Rejected Rows

    Hi,

    I use Powermart 5.1 and have a problem with rejected data.
    I am using Update Strategy transformation to reject records that fail the
    validation. My requirement is to have all invalid records into the reject
    file.

    can anyone help..??
    Thank you!!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact