How to get EVEN & ODD numbers separately?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features of informatica 9.x at the developer level?

609


What is aggregator transformation in informatica?

545


permutations of mapplet

2042


How do you remove duplicate records in informatica? And how many ways are there to do it?

715


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

630






What is the way to execute pl/sql script using informatica mapping?

966


Differentiate between joiner and lookup transformation?

618


Explain the different kinds of facts.

566


EXL informatica Questions

938


What is informatica? Why do we need it?

643


Define mapping and session?

587


Explain what are the different versions of informatica?

657


Which transformation should we use to normalise the COBOL and relational sources?

748


What do you understand by term role-playing dimension?

579


What is sequence generator transformation in informatica?

625