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
- 15300 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 fact table? Explain the different kinds of facts.
How do you use reject loader.
What is dynamic cache?
Performance tuning in UNIX for informatica mappings?
Slowly changing dimensions, types and where will you use them
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the different types of repositories created using informatica?
what is the Default Source Option For Update Strategy Transformation?
What are the various types of transformation?
How to generate sequence numbers without using the sequence generator transformation?
Briefly explain the aggregator transformation?
Can you use flat files in Mapplets.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the databases that informatica can connect to windows?
What does reusable transformation mean?
