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
- 15013 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
To import the flat file definition into the designer where should the flat file be placed?
Mention some types of transformation?
What is aggregator transformation in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How can informatica be used for an organization?
How union transformation is used?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain the tuning lookup transformation - informatica
What is main use of mapplet?
4 yrs etl devloper roles and responsibilities?any body give solutions
Briefly explain the aggregator transformation?
How will the document be delivered to me?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Is there any way to read the ms excel datas directly into informatica?
Define update strategy?
