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
- 14424 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
explain about unit testing? in real time?
Can u generate reports in Informatica?
How can you generate reports in informatica?
What are the different types of olap? Give an example?
Describe the impact of several join conditions and join order in a joiner transformation?
difference between repository database and repository service?
Repository user profiles
what is the Default Source Option For Update Strategy Transformation?
can we override a native sql query within informatica? How do we do it?
How many types of sessions are there in informatica.please explain them?
what are the Methods For Creating Reusable Transformations?
What is DR strategy for Informatica project?
What are different types of transformations available in informatica?
Did u used latest transformations of 8.6.0? for what?
What is informatica powercenter repository?
