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
- 12599 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
What is Cognos script editor?
How do you set a varible in incremental aggregation
How to differentiate between the active and passive transformations?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to elaborate powercenter integration service?
What could be the possible resons of locks by user?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What all join we can perform in LOOKUP transformation?
What is decode in informatica?
What is informatica worklet?
How can we remove the duplicates from flat file source?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How we can create indexes after completing the load process?
