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
- 12598 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
How do you change a non-reusable transformation to reusable transformation?
Explain the different dimensions.
Explain pmcmd command usage in informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the use of transformation?
How can you validate all mappings in the repository simultaneously?
Make a note of the quantity vaults made in informatica?
what are 3 tech challenges/ common issues you face?
Repository user profiles
What are the settings that you use to configure the joiner transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Please let me know how to make Data masking in informatica..
What is the cumulative sum and moving sum?
How you prepared reports for OLAP?
Explain Dataware house architecture .how data flow from intial to end?
