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
- 15101 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
Differentiate between router and filter transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Can we override a native sql query within informatica?
Explain the difference between mapping parameter and mapping variable?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What do you mean by channel change?
Is it possible to revert a global repository to local one and why?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the different types of olap? Give an example?
is it possible to index the data in cache of lkp transformation ?
What is mapping debugger?
What is lookup change?
