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,
Answer Posted / ankit gupta
set commit interval as 100 in WF session and commitType as
target
| Is This Answer Correct ? | 15 Yes | 7 No |
Post New Answer View All Answers
In informatics server which files are created during the session rums?
r u done any partitions in ur project?
State the differences between sql override and lookup override?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
can anyone explain me about retail domain project in informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What do you understand by a term domain?
Is it possible to use a client with different version than that of its Informatica server?
How to join three sources using joiner? Explain though mapping flow.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Where is metadata stored?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the different types of transformation available in informatica.
what are the deliverables?in your project?
Clarify the utilization of aggregator cache record?