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
- 15265 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
Explain informatica architecture - version 8 / 9
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is rank transformation?
can we override a native sql query within informatica? Where do we do it?
Why do you use Mapping Parameter and mapping variable?
What do you understand by a term domain?
How to create Target definition for flat files?
What is an Integration service in Informatica?
How to create a non-reusable instance of reusable transformations?
Whats there in global repository
Explain what are the different versions of informatica?
Why sorter is an active transformation?
How many transformations can be used in mapplets.
What are the limitations of joiner transformation?
