How to load data based on even and odd record numbers

In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?
How can we draw and winch transformations we are using?and explain logic?
  • Interview Candidate
  • 13
  • 12700

Showing Answers 1 - 13 of 13 Answers

Srilatha Sankara

  • Jun 22nd, 2006
 

Use a Router after the source , if the port have the number 1 to 1000  divided by 2 returns 0 then it belongs to Group 1 else Group 2. Send group 1 to one target ,group 2 to 1 target

  Was this answer useful?  Yes

praveen

  • Jul 3rd, 2006
 

hi alll,

As one of friend suggest that good suggestion but if we make two groups and two conditions then it improves performance

i.e even for one condition and one output group

odd for one condition and another output group

regads

praveen

  Was this answer useful?  Yes

anand

  • Oct 4th, 2006
 

use mod function in the expression transformation

to solve this problem ,

  Was this answer useful?  Yes

kishore

  • Nov 1st, 2006
 

use router transformation after source and then use the condition recordnumber/2=0 this is one group another is default group.then we populate these two groups into two targets

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions