GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 34 of 327    Print  
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 wich transformations we r using?and explain logic?

  
Total Answers and Comments: 6 Last Update: February 04, 2009     Asked by: Reddy 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 22, 2006 14:02:38   #1  
Srilatha Sankara        

RE: In Source 1 to 100 numbers? How can we load the e...
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
 
Is this answer useful? Yes | No
July 03, 2006 06:09:47   #2  
praveen        

RE: In Source 1 to 100 numbers? How can we load the e...

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


 
Is this answer useful? Yes | No
October 04, 2006 01:55:31   #3  
anand        

RE: In Source 1 to 100 numbers? How can we load the e...

use mod function in the expression transformation

to solve this problem


 
Is this answer useful? Yes | No
November 01, 2006 09:37:50   #4  
kishore        

RE: In Source 1 to 100 numbers? How can we load the e...
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
 
Is this answer useful? Yes | No
October 24, 2008 01:18:31   #5  
arun.menon Member Since: October 2008   Contribution: 4    

RE: 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 wich transformations we r using?and explain logic?
Use mod function in Expression transformation to resolve this problem.

Cheers
Arun

 
Is this answer useful? Yes | No
February 03, 2009 23:44:17   #6  
prade Member Since: May 2008   Contribution: 6    

RE: 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 wich transformations we r using?and explain logic?

Use a router on Mod (2)... for 1 route to odds-target and for 0 even-target.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape