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
- 12548 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
How can you generate reports in informatica?
Explain the scenario which compels informatica server to reject files?
Which is the t/r that builts only single cache memory?
What is lookup change?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the types of presistent cache in look up tr.
What are the different types of olap? Give an example?
Plz can any one say me how to get the informatica certification materials and dumps
What is joiner transformation?
What are the tuning techniques you applied during your last project
r u done any partitions in ur project?
What is the difference between stop and abort in informatica
What is the procedure for creating independent data marts from informatica 7.1?
What are the different transaction levels available in transaction control transformation?
What is standalone command task?
