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
- 15541 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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How can we use mapping variables in informatica? Where do we use them?
Explain what transformation and how many are there in informatica?
difference between informatica 8.1.1 and 8.6
Why sorter is an active transformation?
Enlist some properties of sessions.
How to generate or load values in to the target table based on a column value using informatica etl tool.
Can you generate sequence numbers without using the sequence generator transformation?
What is main use of mapplet?
Explain dynamic target flat file name generation in informatica
Informatica Checkpoints
What are the types of lookup transformation?
what is the size of your data warehousing?
How to create Target definition for flat files?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
