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

Briefly describe lookup transformation?

596


Explain the different lookup methods used in informatica?

582


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

592


When do you use sql override in a lookup transformation?

579


Explain incremental aggregation in informatica

650






How can we store previous session logs?

563


What is xml source qualifier transformation in informatica?

709


What is event and what are the tasks related to it?

611


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1964


What are the different types of repositories created using informatica?

651


Under what condition selecting sorted input in aggregator may fail the session?

655


Where are the source flat files kept before running the session?

622


How can we handle two sessions in informatica?

610


What are the components of Informatica? And what is the purpose of each?

614


Please let me know how to make encryption and decryption with example?

1460