Interested to Buy Any Domain ? << Click Here >> for more details...
Hello Everyone,i have one question on sequence generator.i
have two targets and the records comes from the source will
place in the targets like 1-10 rec in target1 and 11-20 rec
in target2,21-30 rec in target1...etc so any one can help
me? plz..Thanq in adv.
- 7 Answers
- 15537 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answer Posted / santosh_dw
It will work without making sequence generator cyclic
select mod(floor(3/10),2) from dual;
Ans: 0
select mod(floor(12/10),2) from dual;
Ans: 1
select mod(floor(25/10),2) from dual;
Ans: 0
select mod(floor(35/10),2) from dual;
Ans: 1
Thanks,
Santosh.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Under what condition selecting sorted input in aggregator may fail the session?
What is domain and gateway node?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is meant by lookup transformation? Explain the types of lookup transformation?
draw informatica architecture 8.6 ?
Under which circumstances, informatica server creates reject files?
what is size of u r database?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How we can create indexes after completing the load process?
What is informatica powercenter repository?
Target increases every day even though no new record was inserted
What are the prerequisite tasks to achieve the session partition?
What are roles and groups and benefits of using them?
