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
- 15302 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar sarangi
1.Take a sequence generator and connect it to the expression
t/r.
2.In expression transformation create a out put post and
keep the below condition;
VAL_OUT = iif(mod(floor((nextval-1)/10),2)=0,0,1)
3.Keep a router t/r, and filter with the condition VAL_OUT=0
then first target and if VAL_OUT=1 then second target.
Let me know if any thing wrong.
Thanks & Regads
Santosh Kumar Sarangi
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is meant by active and passive transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Can we override a native sql query within informatica?
Is it possible to create multiple domains on a single Informatica server?
What are the restrictions of union transformation?
What are roles and groups and benefits of using them?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Mention some types of transformation?
Why do we need informatica?
What do you mean by blocking transformation?
What are the settings that you use to configure the joiner transformation?
What is an aggregator transformation?
without table how to come first record only in oracle?
What are batches?
What is data caches/ index caches?
