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
- 15540 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi,
Mappimg::
SRC=>SQ=>SEQ GEN=>EXP=>RTR=>TRG1 &TRG2
First we have to take 4 mapping variables,those are
VAR1=1 increment by 20
VAR2=10 increment by 20
VAR3=11 increment by 20
VAR4=20 increment by 20
in RTR two groups are there group 1::
IIF( NEXTVAL>=VAR1 AND NEXTVAL<=VAR2)
GROUP 2 :: IIF( NEXTVAL>=VAR3 AND NEXTVAL<=VAR4)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is informatica?
What are the guidelines to be followed while using union transformation?
What is decode in informatica?
Slowly changing dimensions, types and where will you use them
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is rank transformation?
How to create a non-reusable instance of reusable transformations?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is repository manager?
Sequence generator, when you move from develoment to production how will you reset
Differentiate between joiner and lookup transformation?
Separate from an archive server and a powerhouse?
Can you generate sequence numbers without using the sequence generator transformation?
How you can differentiate between connected lookup and unconnected lookup?
explain one complex mapping with logic? sales project?
