Interested to Buy Any Domain ? << Click Here >> for more details...
Hi All,
I've 110 records in my table but 101 records contains an
error. When I run the session, I want to load the 100
records into the target. Can anyone suggest me the best
solution for this...
Thanks in Advance,
- 7 Answers
- 16327 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / srinivas
i believe this would certainly serve your purpose.
connect your source to filter transformation. if your
source contains p_key then the condition should be
p_key<=100. if it doesnt containa a primary key ex a flat
file create a new port in the filter transformation name it
s_no and connect the nextval port of seq.gen and the
condition shud be s_no<=100 and connect to the target.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
How do you change a non-reusable transformation to reusable transformation?
Describe expression transformation?
In informatica workflow manager, how many repositories can be created?
What is the sequence generator transformation in informatica?
State the differences between sql override and lookup override?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the difference between stop and abort in informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Define joiner transformation?
Did u used latest transformations of 8.6.0? for what?
Explain the different kinds of facts.
What is meant by query override?
What are the different types of transformation available in informatica.
What are the issues you have faced in your project? How did you overcome those issues?
How do we call shell scripts from informatica?
