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.
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 many transformations can be used in mapplets.
What are the different options available for update strategy?
What are the new features of informatica 9.x in developer level?
What is persistent lookup cache?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What does cheating measurement mean?
How are the sources and targets definitions imported in informatica designer?
What is meant by incremental aggregation?
what are the deliverables?in your project?
how tokens will generate?
What is data movement mode in Informatica and difference between them?
Please let me know how to make encryption and decryption with example?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
is it possible to index the data in cache of lkp transformation ?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa