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
- 14988 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
How are the sources and targets definitions imported in informatica designer?
What is the way to execute pl/sql script using informatica mapping?
What is a joiner transformation?
What is an unconnected transformation?
What is xml source qualifier transformation in informatica?
Can we create multiple integration service on single repository?
COM components can be used in Informatica
what is $$$$?
How you prepared reports for OLAP?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What do you understand by SOA of Informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the need for an etl tool?
What is the difference between informatics 7x and 8x and what is latest version?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
