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


Please Help Members By Posting Answers For Below Questions

Define sessions in informatica etl?

609


What are the types of lookup transformation?

624


How can you increase the performance in joiner transformation?

695


What are the measure objects?

647


Write the prerequisite tasks to achieve the session partition?

631






explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1695


can anyone explain me about retail domain project in informatica?

7413


What is the command used to run a batch?

563


Enlist the tasks for which source qualifier transformation is used.

576


Can we create multiple integration service on single repository?

693


How identifying bottlenecks in various components of informatica and resolving them?

573


Design time, run time. If you don't create parameter what will happen

1413


generate date / time dimension in informatica

709


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

624


Tell me about Propagate functions in informatica

514