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 / ritu sharma
go the source and there is a property of skip the number of
rows.set it to 1 and then save the mapping and run the workflow.
Ritu Sharma
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
How might one distinguish in the case of mapping is right or not without associating session?
Differentiate between source qualifier and filter transformation?
What is the difference between router and filter?
What is meant by active and passive transformation?
what are 3 tech challenges/ common issues you face?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Sequence generator, when you move from develoment to production how will you reset
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is sequence generator transformation in informatica?
How to handle decimal places while importing a flatfile into informatica?
Explain lookup transformation in informatica
How can you validate all mappings in the repository simultaneously?
What are the measure objects?
What is decode in informatica?