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
- 16313 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
What is meant by target load plan?
What is the Process to creating lookup transformation in informatica
What is workflow? What are the components of workflow manager?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the new features of informatica 9.x developer?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Performance tuning in UNIX for informatica mappings?
What are the static cache and dynamic cache in informatica?
What is a passive transformation?
What is complex mapping?
what is INFORMATICA TESTING process
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the types of caches in lookup? Explain them.
How an expression transformation differs from aggregator transformation?
How to join three sources using joiner?
