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
- 15273 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
Explain the different kinds of facts.
Explain lookup transformation in informatica
Make a note of the quantity vaults made in informatica?
How to update a particular record in target with out running whole workflow?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the difference between Active and Passive transformation?
What differs when we choose the sorted input for aggregator transformation?
What is a difference between complete, stop and abort?
To import the flat file definition into the designer where should the flat file be placed?
Differences between version 7.x and 8.x.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What do you mean by enterprise data warehousing?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How you can differentiate between connected lookup and unconnected lookup?
What is the fact table?
