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
- 15330 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 any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is a code page?
Which transformation should we use to normalise the COBOL and relational sources?
What does command task mean?
what is unit testing?tell me proceedure
Can informatica load heterogeneous targets from heterogeneous sources?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to improve the performance of a session using sorter transformation?
What is a snowflake schema?
Performance tuning( what you did in performance tuning)
Why filter transformation is an active one?
What is a router transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is blocking transformation?
Explain how many types of dimensions are available in informatica?
