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
- 15011 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answer Posted / krish
i didnt get ur scenario ur saying that 1-10 11-20 this
should continue.
if this is the thing u need to check the cycle option
increment by 1
end value 20
current value 0
check reset(to be on safe side)
in exp create to o/p ports
like first_10values
second_10values
then take router
in that give first_10VALUES<11;
GIVE THAT CONNECT INTO ONE TARGET
AND THE DEFAULT INTO ANOTHER TARGET.
give the condition
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Explain what are the different versions of informatica?
Please let me know how to make encryption and decryption with example?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How can a transformation be made reusable?
Why update strategy and union transformations are active? Explain with examples.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Where is metadata stored?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is rank index in rank transformation?
without table how to come first record only in oracle?
Explain dynamic target flat file name generation in informatica
How to do unit testing in informatica?
How to update a particular record in target with out running whole workflow?
What is an unconnected transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
