Interested to Buy Any Domain ? << Click Here >> for more details...
How to get EVEN & ODD numbers separately?
- 8 Answers
- 26819 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amedela chandra sekhar
By using the condition in router transformation
drop the required ports into router t/r
add one group
even mod(empno,2)=0 ------Target1
defaultgroup -------------Target2
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / raghava
data one;
input number 10.;
datalines;
10
11
12
13
14
15
16
17
18
19
20
;
run;
data two;
set one;
if mod(number,2)=0 Then A=number; else B=number;
/* number=mod(number);*/
run;
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / tejeya
By using the Sequence generator and Mod() in Expression tfn.
| Is This Answer Correct ? | 9 Yes | 6 No |
There are many ways....
1) Using the sql override in the source qualifier. To find
the even and odd. Add another column to flag the even and
odd.Like
select ID,decode( id/2,0,'E','O') FLAG FROM TABLE_NAME;
Using the router we can send them into two seperate target
tables.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / amedela chandra sekhar
for above answer
Remember empno should be like
1
2
3
4
5
6
7
8
9
other wise drag nextval port from sequence generator to
union t/r give condition like mod(nextval,2)0
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / prasad
no
1
2
3
4
5
6
7
8
9
10
i wrote a condition in transformer if mod(no,2)=0 Then B else A
Target
A
1
3
5
7
9
Target
B
2
4
6
8
10
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / vali
by using the condition in expression transformation
mod(empno) .the output given torouter t/r. if the o.p is
zero given to one group and if one given to default group..
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / usha
by using Sequence Generator transformation we can get even
to one target and odd to other target
end valu=2
cycle should enable
start val=1
curr value=1
s-->sq-->seq-->RTR-->t1-->t2
| Is This Answer Correct ? | 1 Yes | 2 No |
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
Enterprise data warehouse your projects phase by phase explain?
What are the connected or unconnected transforamations?
performance wise which one is better in joiner and lookup transformation
Explain joiner transformation in informatica
What exactly mentioned in High level design document.can somebody explain me sequentialy.
What are the different types of Type2 dimension maping?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
What is incremental aggregation?
Examples of Fatal & Non-Fatal error?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
what is the hint? how to use it to reduce the query processing in program?
Teradata 
